Re: left join two tables

Hi Johan, I think you probably want something like this. Give the following a shot. SELECT * FROM table1 LEFT JOIN table2 ON table1.ID = table2.subID LEFT JOIN table3 ON table1.ID= table3.subID On Thu, Apr 28, 2011 at 9:41 AM, Johan De Meersman wrote: > Hey there, > > - Original Message -

Re: left join two tables

Hey there, - Original Message - > From: "Rocio Gomez Escribano" > 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 sugg

left join two tables

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 Thanks!!! Rocío Gómez Escribano r.go...@ingenia-soluciones.co