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.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]
