Outer join

From: <hberle_at_my-deja.com>
Date: Thu, 14 Oct 1999 09:14:16 GMT
Message-ID: <7u46t3$8pa$1@nnrp1.deja.com>

I have one main table which contains a number of fields, out of these fields I have two fields which must be looked up in two other tables using a join, however these two fields may also be null and I can not make an outher join on the same table to more than one other table how can this be solved ?

I want to obtain a list of rows from the main table even the rows which contains null for the two fields.

Thanks,
Henrik

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 04:14:16 CDT