At 12:20 PM 8/15/2008, [EMAIL PROTECTED] wrote:
Date: Fri, 15 Aug 2008 13:46:14 -0400
From: "Edward W. Rouse" <[EMAIL PROTECTED]>
To: <pgsql-sql@postgresql.org>
Subject: Re: Join question
Message-ID: <[EMAIL PROTECTED]>

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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to