Thanks, Dmitry, that was it. I stared blankly at this page for a while and it didn't click. Took someone to steer me to it.
The solution is simple: "SELECT fld1, GROUP_CONCAT(t3.fld5) etc 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" All I was missing was GROUP_CONCAT prefixing each field I wanted concatenated. I guess it's the string equivalent of AVG(), SUM() etc Thanks again --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
