reva(dot)d91(at)gmail(dot)com writes:
> It is ignoring the invalid columns in subquery,Instead of throwing the error
> 'Column does not exist'.
> (eg):
> select * from emp where (empname,empid,empno) in(selec emname,emid,emno from
> em_details)
> Note:There is no emno in em_details table.
Maybe not, but if there is one in emp, then this query is legal per
SQL spec --- emno is an outer reference.
regards, tom lane