JOINT Three tables with sql query

Jun 13 2009 11:04 AM

hello;
I am developping an application with five tables:
the first, second, third and forth table contain one row,
the fifth table contain 12 row;
I would like to retreive this data in one row,
I tried this query but it gives me twelve (12) line
"SELECT DISTINCT table1.*, table2.*, table3.*, tale4.*, table5.* FROM " + "(((table1 LEFT JOIN tabl5 ON table1.Ref1 = table5.Ref1) INNER JOIN table2 ON table1.RefFT = table2.Ref1) " +
"LEFT JOIN table3 ON table1.Ref1 = table3.Ref1) LEFT JOIN (PIECES.*, " + "ON table3.Id_table3 = table4.Id_table3) WHERE (((table1.text1)=" + "32" + "))";
 
please help me
best rEGARD

Answers (1)