On Wed, 1 Oct 2003 16:58:26 -0500, sean peters <[EMAIL PROTECTED]> wrote: [...] | 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; | [...] | | 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.
SELECT A_data, B_data, C_data FROM A LEFT JOIN B ON A.A_ID = B.A_ID LEFT JOIN C ON A.A_ID = C.A_ID WHERE A.A_ID = 4; That should do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]