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 -
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
