try: select * from MapConfig mc LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = "Roads";
-----Original Message----- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 4:24 PM To: [EMAIL PROTECTED] Subject: Linking tables using INNER JOIN I am trying to do an inner join between three tables. Here is what I have tried: select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt USING (id) WHERE MapConfig.layername = "Roads"; What I am trying to do is to pull back all rows from MapConfig associated with matching rows from ConfigInt and ConfigString. What I get, though, is info from MapConfig and ConfigString ONLY, nothing from ConfigInt. If I rearrange the order that ConfigString and ConfigInt appear, I get info from MapConfig and ConfigInt ONLY, nothing from ConfigString. Is my SQL messed up or is there a limitation in MySQL on the number of INNER JOINs you can do in one statement? I suppose I could probably use a temporary table for this but I'd rather not. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
