[GENERAL] JOIN of a table with many detail tables

[DaVinci]

 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