Re: Join question

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