The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Classic JOIN help
I have two tables: mailmessage and mailfolder. This query works perfectly (returns the number of messages in each folder) except for when one folder doesn't have any messages.
I know I have to use a JOIN to solve this. How do I do it? [sql] SELECT mf.mailfolderid, mf.title, COUNT(mm.mailmessageid) AS messagecount FROM mailmessage mm, mailfolder mf WHERE mf.mailfolderid = mm.mailfolderid AND mf.userid = 1 AND mm.userid = 1 GROUP BY mf.mailfolderid [/sql] If you want I can give a schema for both tables but you shouldn't need it, I think. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|