How can I change where Clause to Joins . .

[SajidAttar]

Hi!

I have following query.

    Select a.* 
    From Table1 a 
      where [blue] not exist (
      select * from Table2 b 
      where a.col1 = b.col1 and a.col2 = b.col2 ) [/blue]

I want to get rid of WHERE clause.

Is there a way to use join (Inner/outer) to retrieve the same result as above query.

Thanks in advance,





Regards,


"There are no secrets to success. It is the result of preparation, hard work, and learning from failure." -- Colin Powell

 

[bborissov]

Select a.*
      From Table1
      LEFT JOIN Table2 ON Table1.col1 = Table2.col1 and Table1.col2 = Table1.col2
      where Table2.Col1 IS NULL

You can't ged rid from WHERE clause

Borislav Borissov

 

[SajidAttar]

Thanks Borislav Borissov


Regards,


"There are no secrets to success. It is the result of preparation, hard work, and learning from failure." -- Colin Powell