On Mon, 15 Dec 2003, Ravinder Bhalla wrote:
> Does that mean
>
> Both the following query will throw same result (assuming empname aslo exist
> in Dept)
>
> select * from emp where empid in ( select empname from dept);
I think this is effectively the same as:
select * from emp where empid=empname and exists(select 1 from dept)
> select * from emp where empid in ( select empid from dept) ;
And this one would be:
select * from emp where empid=empid and exists(select 1 from dept)