Re: subquery abnormal behavior

I just noticed the same behavior in Oracle and SQL Server as well :)

Regards,
---------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/11/06, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:
>
> I just noticed an abnormal behavior for the subquery:
>
> create table myt1 (a numeric);
> create table myt2 (b numeric);
>
> select a from myt1 where a in (select a from myt2);
>
> This should be giving an error that column 'a' does not exist in myt2 but
> it runs with any error...
>
> I had been trying it on 8.2!
>
> Can someone please comment?
>
> Thank you,
> -------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>