Hi there, I do want to pull out some data of a user. I did normalize the tables, so there is a table for website, comment ...
Now I would like to pull out the users website, comment.. but only if there is one. Unfortunatelly my select stmt returns all 50000 records of the website table: SELECT w.website, c.comment, i.icq, s.signature FROM user_websites LEFT JOIN user_comments AS c ON c.user_id = '3' LEFT JOIN user_icq AS i ON i.user_id = '3' LEFT JOIN user_signature AS s ON s.user_id = '3' LEFT JOIN user_websites AS w ON w.user_id = '3' Somehow my syntax must be wrong, but I can not find the error :-( Maybe one of you guys does know why. Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php