Re: Outer join

From: Yosi Greenfield <ygreenfield_at_compuserve.com>
Date: Thu, 14 Oct 1999 14:27:26 -0400
Message-ID: <3806208E.2C864D98@compuserve.com>

Try using a stored database function to lookup the other tables. You can avoid the outer join altogether and you'll save loads of time.

This works best if the lookups to the other tables can be indexed.

HTH, Yosi

hberle_at_my-deja.com wrote:

> 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 - 13:27:26 CDT