db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guy <guy.van.tilbo...@gmail.com>
Subject OUTER JOIN on more than one table
Date Fri, 29 Sep 2006 12:55:25 GMT
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?


View raw message