Hi guys, I'm stuck on a MySQL query problem. I want to put the result of two ids in the same table into one row, based on an id in a third row.
eg: "SELECT * FROM table1 AS t1 LEFT JOIN table2 AS t2 ON t1.fld1 = t2.fld1 LEFT JOIN table3 AS t3 ON t2.fld2 = t3.fld2 LEFT JOIN table4 AS t4 ON t2.fld2 = t4.fld2 GROUP BY fld1" For each row fld1 has only one value hence the GROUP BY, but fld2 can have two values. What I want is to have any content from table3 and table4 that has a fld2 that is linked to fld1 included in each row of the query. Then I want to sort on fields from both table3 and table4, so creating 2 queries is not going to help (or is it?). I've searched the net but can't find out how I might do this. Any pointers would be greatly appreciated. --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
