Select Distinct col1, col2, col3 ...
From Tab1 T1
Where Not Exists ( Select Null From Tab2 T2
Where T1.Col1 = T2.Col1 and T1.Col2 = T2.Col2 ..... )
This will Give you the desired result...
Hope will help
Thanks
|
Results 1 to 5 of 5
Thread: SQL HelpThreaded View
|
Click Here to Expand Forum to Full Width |