Sorry, I had an error in my query. The fixed query with the entire post
follows.
Thanks for the responses to the incorrect one, im pretty sure that the
suggestions will still fail for the previously indicated reasons, even with
the modified query.
ORIGINAL POST: (fixed)
I've run into a situation where i dont know how to best write a query. For a
base example, consider these 3 tables:
CREATE TABLE A (
A_ID INT NOT NULL PRIMARY KEY,
A_data text
);
CREATE TABLE B (
B_ID INT NOT NULL PRIMARY KEY,
A_ID INT NOT NULL,
B_data text
);
CREATE TABLE C (
C_ID INT NOT NULL PRIMARY KEY,
A_ID INT NOT NULL,
C_data text
);
So ive been running a query like:
SELECT A_data, B_data, C_data FROM A, B, C
WHERE A.A_ID = B.A_ID
AND A.A_ID = C.A_ID
AND A.A_ID = 4;
*** ORIGINAL INCORRECT QUERY :( ***
SELECT A_data, B_data, C_data FROM A, B, C
WHERE A.A_ID = B.B_ID
AND A.A_ID = C.C_ID
AND A.A_ID = 4;
What i really want is to get the A_data from A, and if there are cooresponding
records in B and/or C, get B_data and/or C_data, respectively.
This works fine if there are cooresponding records in tables B and C for each
record in A, but if not, this returns nothing.
So, short of querying each table, i cant come up with a good solution to my
problem.
If there were only 2 tables, a LEFT JOIN would work fine, but both B and C
want to be left joined to A, which i dont know how to do.
thanks
sean peters
[EMAIL PROTECTED]
---
mysql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
