> I want to make a LEFT JOIN of table A with detail tables B and C. How can
I
> make that?:
>
> SELECT A.*, B.*, C.* FROM A LEFT JOIN B ON A.foo = B.bar ???????
>
> I don't know where to put info of JOIN between A and C.
>
> Any help, please? Thanks.
SELECT * FROM A LEFT JOIN B ON A.foo = B.bar LEFT JOIN C ON A.foo = C.bar
Should do it.
Greg