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