I'm pretty sure an outer join between A+B and C+B would be like this:
SELECT *
FROM A LEFT OUTER JOIN B ON A.PK = B.PK
RIGHT OUTER JOIN C ON B.PK = C.PK;
--
Bill Karwin (bill@lutris.com)
Application Architect - Lutris Technologies Inc.
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|