Oh that explains a lot...
Thank you,
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/11/06, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On Dec 11, 2006, at 15:48 , Shoaib Mir wrote:
> create table myt1 (a numeric);
> create table myt2 (b numeric);
>
> select a from myt1
On Dec 11, 2006, at 15:48 , Shoaib Mir wrote:
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...
The a in the IN clause is the
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 n
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 b
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.
