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
mailto:r.sanc...@ingenia-soluciones.com r.go...@ingenia-soluciones.com
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
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 vegiv...@tuxera.be wrote:
Hey there,
-