Skip Evans wrote:
Hey all,
I have the following query:
$sql="SELECT count(*) AS
count,votes.storyID,stories.title,stories.storyID as
sID,stories.approved, stories.story,stories.userID, fname, lname
FROM `bsp_story_votes` as votes, bsp_story_stories AS
stories, users AS usr
WHERE votes.storyID=stories.storyID AND
stories.userID=usr.id AND stories.contestID=$contestID
GROUP BY votes.storyID
ORDER BY stories.approved,count DESC, sID ASC LIMIT
$b_recno,$recs";
How would this need to be changed so that it would return rows for the
members of the bsp_story_stories table that do not have records in the
bsp_story_votes table?
Is that what the left/right joins do???
Look up 'left outer join'
I believe that is what you are looking for.
-B
Thanks!
Skip
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
