Re: understanding NOT IN / IN
From: ciapecki <ciapecki_at_gmail.com>
Date: Tue, 17 Feb 2009 12:45:26 -0800 (PST)
Message-ID: <44d52482-3658-4e87-a3c6-ea2c7365c941_at_g38g2000yqd.googlegroups.com>
>
> Yes, it is based on table column scope. Instead of being b.org_id as
> you would think from reading the subquery it is a.org_id. A good
> reason to always alias your tables and prefix the alias to your column
> in all sub-queries.
>
Date: Tue, 17 Feb 2009 12:45:26 -0800 (PST)
Message-ID: <44d52482-3658-4e87-a3c6-ea2c7365c941_at_g38g2000yqd.googlegroups.com>
>
> Yes, it is based on table column scope. Instead of being b.org_id as
> you would think from reading the subquery it is a.org_id. A good
> reason to always alias your tables and prefix the alias to your column
> in all sub-queries.
>
thanks everyone for elaborating on this.
thanks,
chris
Received on Tue Feb 17 2009 - 14:45:26 CST