Re: Join question

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Join question
Дата
Msg-id 396486430808151010x1e158cfcvabeb12728c9cfc5d@mail.gmail.com
обсуждение исходный текст
Ответ на Join question  ("Edward W. Rouse" <erouse@comsquared.com>)
Ответы Re: Join question  ("Edward W. Rouse" <erouse@comsquared.com>)
Список 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 по дате отправления:

Предыдущее
От: "Edward W. Rouse"
Дата:
Сообщение: Re: Join question
Следующее
От: "Edward W. Rouse"
Дата:
Сообщение: Re: Join question