At 12:20 PM 8/15/2008, pgsql-sql-owner@postgresql.org wrote:
>Date: Fri, 15 Aug 2008 13:46:14 -0400
>From: "Edward W. Rouse" <erouse@comsquared.com>
>To: <pgsql-sql@postgresql.org>
>Subject: Re: Join question
>Message-ID: <04da01c8fefe$d01f9c60$705ed520$@com>
>
>I did try that, but I can't get both the values from table a with no
>entries
>in table b and the values from table b with null entries to show up.
>It's
>either one or the other.
>
>Edward W. Rouse
Might have luck with applying some additional WHERE clause criteria to
your full outer join. So if you don't want certain types NULL's in
table b, restrict against that in WHERE clause? I could be
misunderstanding the whole thing though..
Steve