Re: Join question - Mailing list pgsql-sql

From Richard Broersma
Subject Re: Join question
Date
Msg-id 396486430808151010x1e158cfcvabeb12728c9cfc5d@mail.gmail.com
Whole thread Raw
In response to Join question  ("Edward W. Rouse" <erouse@comsquared.com>)
Responses Re: Join question  ("Edward W. Rouse" <erouse@comsquared.com>)
List pgsql-sql
On Fri, Aug 15, 2008 at 9:48 AM, Edward W. Rouse <erouse@comsquared.com> wrote:

> The problem is I also have to include
> items from table b with that have a null user. There are some other criteria
> as well that are simple where clause filters. So as an example:

instead of left join try FULL OUTER JOIN.

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


pgsql-sql by date:

Previous
From: "Edward W. Rouse"
Date:
Subject: Re: Join question
Next
From: "Edward W. Rouse"
Date:
Subject: Re: Join question