Re: problems with left outer join

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