Jump to content

Doubled Left join query comes out NULL


Alchemy

Recommended Posts

When I run this query on my server, the results are completely empty... I'm trying to learn how to write complicated sql queries so that I don't have to have hundred of simple ones running on every page of my CMS.... Here;s the query in question.

[code]SELECT
quotes.*,
user.userid, user.username, user.displaygroupid, user.usergroupid,
usergroup.usergroupid, usergroup.opentag, usergroup.closetag,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM cms_quotes AS quotes
LEFT JOIN vb_user AS user ON(quotes.quote_added_by = user.userid)
LEFT JOIN vb_usergroup AS usergroup ON(user.displaygroupid = usergroup.usergroupid)
WHERE quotes.quote_approved IS NOT NULL
ORDER BY RAND() LIMIT 1[/code]

Now, since there are table entires that have quote_approved not being null... I don't understand why the query runs without error, but then the results come in null.... any help would be greatly appreciated.
Link to comment
https://forums.phpfreaks.com/topic/28490-doubled-left-join-query-comes-out-null/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.