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 <[EMAIL PROTECTED]> 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)
