All Forums General
Purushotham 87 posts Joined 04/14
02 Sep 2014
Without using Join keyword how can we retrive matching rows from both the tables

Hi,
 
Could anyone pls share me a query .without  using join keyword  how can we retrive the matching rows from both the tables..
 
Regards,
Purushotham..
 

Purushotham.M
Raja_KT 1246 posts Joined 07/09
02 Sep 2014

Can you use  intersect ,exists, (not exists), in , (not in), .....union n minus ......? or is it an inhibition that join should not be used at all?
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

ToddAWalter 316 posts Joined 10/11
03 Sep 2014

If the question is just the join keyword then just use the traditional join syntax:
SELECT * FROM A, B WHERE A.C1=B.C1;

You must sign in to leave a comment.