Thread: JOIN of a table with many detail tables

 Hi all.

 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.

                                                         David

>  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