Help wtih a query?

From: Date: Tue, 30 Jan 2007 22:33:37 +0000
Subject: Help wtih a query?
Groups: php.general 
Request: Send a blank email to php-general+get-248067@lists.php.net to get a copy of this message
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??? Thanks! Skip -- Skip Evans Big Sky Penguin, LLC 61 W Broadway Butte, Montana 59701 406-782-2240 http://bigskypenguin.com =-=-=-=-=-=-=-=-=-= Check out PHPenguin, a lightweight and versatile PHP/MySQL development framework. http://phpenguin.bigskypenguin.com/

« previous php.general (#248067) next »