Re: understanding NOT IN / IN

From: ciapecki <>
Date: Tue, 17 Feb 2009 12:45:26 -0800 (PST)
Message-ID: <>

> 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.

chris Received on Tue Feb 17 2009 - 14:45:26 CST

Original text of this message