Postgres Pro
Downloads
Home   >   mailing lists

Re: problems with left outer join - Mailing list pgsql-novice

From Andy Chambers
Subject Re: problems with left outer join
Date
Msg-id 20061005132604.GB1353@andy.fridgeproject.com
Whole thread Raw
In response to problems with left outer join  ("Andreas Andreakis" <andreas.andreakis@googlemail.com>)
List pgsql-novice
Tree view 
On 10:13 Thu 05 Oct     , Andreas Andreakis wrote:
> Hi,
>
> So I tried:
>
> select *
> from A t1 left outer join B t2 on t1.id = t2.id
> where t2.id = null

Swap '=' with 'is'

Regards,
Andy





___________________________________________________________
All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of use." - PC Magazine
http://uk.docs.yahoo.com/nowyoucan.html

pgsql-novice by date:

Previous
From: Ray Stell
Date:
Subject: Re: postgresql db account
Next
From: Tom Lane
Date:
Subject: Re: problems with left outer join