Hey there, ----- Original Message -----
> From: "Rocio Gomez Escribano" <r.go...@ingenia-soluciones.com> > Hi!! Is it possible to create a left join consult with 2 tables?? > I mean: > SELECT * FROM table1 LEFT JOIN (table2, table3) on table1.ID = > table2.subID and table1.ID= table3.subID Pretty close already. Might I suggest sampling the fine manual ? Have a look at http://dev.mysql.com/doc/refman/5.0/en/join.html -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel