Wow! What have you got against readability? Rule 1: Give things meaningful names! How would you cope with life if your dining table was called "thing1", the door "thing23", and your childres "thing97", thing128a" and "thing128b" (the twins)? Also: Did you look at the example I sent? Each table you add needs a separate 'JOIN'. I didn't use an 'and' anywhere. With respect, I think that you are out of your depth here. But if you want to keep trying, try to get 3 tables working by replacing a, b, and c with your table names, and use SELECT * so you don't have to mess around with all the names. Then try to add the 4th table. If I understand you attempt, you don't need any parentheses at all. And really you'd be better off setting up foreign keys, but let's try to get it working like this first, okay? Ian
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/HKFolB/TM --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
