Popular posts

Hi Akshat, A correlated subquery would have an inner join like this:

select * from table1 where exists (select 1 from table2 where table1.col1=table2.col1);

you are connecting via a join within the sub select.