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