You can (inner/outer) join the result of a join with another table. Use parntheses to group the joins.

Vlad

>Can I have more than one table to the left of a join statment in an SQL syntax? I have six tables. Tables A & B are related to table C. Table C is related to table D. Tables E & F are related to table D. I need to create an SQL statement from all these tables using inner and outer joins.
>
>TIA
>
>Alhad