Re: problems with left outer join

From: Andy Chambers <andychambers2002(at)yahoo(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: problems with left outer join
Date: 2006-10-05 13:27:06
Message-ID: 20061005132604.GB1353@andy.fridgeproject.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-10-05 13:35:07 Re: problems with left outer join
Previous Message Ray Stell 2006-10-05 12:54:22 Re: postgresql db account