select * from T1 where x in ( select y from T2 )çalışması:select * from t1, ( select distinct y from t2 ) t2where t1.x = t2.y;Subquery sonucta, distinct, ve indexli (hashed veya sorted) ve join yapmısoriginal tabloyla.Tersi iseselect * from t1 where exists ( select null from t2 where y = x )Bunun calisması: … Continue reading In Exist KARSILASTIRLMASI