RE: [PHP] SQL help

You'll need to do a left/right outer join. as you didn't say which database you're using, I'll give this back to you to do some reading up on how to do it... HTH Martin > -----Original Message----- > From: Marc Greenstock [mailto:marc@shockmedia.com.au] > Sent: Wednesday, 11 February 2004 1:53 PM > To: php-general@lists.php.net > Subject: [PHP] SQL help > > > Hi all here's my problem, > > I have two tables: 'user_data' and 'image_data' > > obviously user_data has all the user information and > image_data has all the > image information > > in image_data are the fields: Image_ID int(11), User_ID int(11) and > Default_Img enum('Yes','No'). Users can have as many images > as they like, > but it is optional. > > I want to select from user_data and image_data and get the > results based > upon the rest of the query. The problem is my sql is only > pulling out the > users with images and ignoring the rest > > my sql looks like this: > > SELECT * FROM user_data, image_data > WHERE user_data.User_ID = image_data.User_ID > AND image_data.Default_Img = 'Yes' > GROUP BY user_data.User_ID > > thanks for your help. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >