Sorry, I'll put it in graphic form
table1 ONE ----------------------- fld1 - primary key table2 MANY (2 that is) ----------------------- fld2 - primary key fld1 table3 ONE ------------------------ fld2 - primary key table4 ONE ---------------------- fld2 - primary key Table3 and table4 link to table2 by the same field but using different values. I am trying to get into one row the (unique) value of fld1, the two values of fld2 and the contents of table3 and table4 that correspond to fld2 in both those tables. Is that clearer? --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
