Skip site navigation (1) Skip section navigation (2)

Re: Join question

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Join question
Date: 2008-08-15 17:10:27
Message-ID: 396486430808151010x1e158cfcvabeb12728c9cfc5d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Fri, Aug 15, 2008 at 9:48 AM, Edward W. Rouse <erouse(at)comsquared(dot)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

In response to

Responses

pgsql-sql by date

Next:From: Edward W. RouseDate: 2008-08-15 17:46:14
Subject: Re: Join question
Previous:From: Edward W. RouseDate: 2008-08-15 17:09:20
Subject: Re: Join question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group