Without using Join keyword how can we retrive matching rows from both the tables

General
Enthusiast

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..

2 REPLIES
Enthusiast

Re: Without using Join keyword how can we retrive 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?

Teradata Employee

Re: Without using Join keyword how can we retrive matching rows from both the tables

If the question is just the join keyword then just use the traditional join syntax:

SELECT * FROM A, B WHERE A.C1=B.C1;