OUTER JOIN on more than one table

[Guy]

Hi all,

i am pretty new to Derby so maybe this is a stupid question, but i couldn't find it in the documentation:

is there a way in Derby to combine OUTER JOINS on one table?

For example:

we have a MAIN table and some SUB tables (SUB1, SUB2...) which all contain MAIN's primary key.

Is it possible to create a select that can see the MAIN table weither or not the SUB tables have records linked to MAIN?

Thanx