Could anyone pls share me a query .without using join keyword how can we retrive the matching rows from both the tables..
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?
If the question is just the join keyword then just use the traditional join syntax:
SELECT * FROM A, B WHERE A.C1=B.C1;