Suppose we have two tables T1 and T2 as described below:
Col 1 Col2 Valid
1 a 120
2 b 232
1 b 435
3 a 123
2 c 532
Col 1 Col2 Invalid
1 a 1133
2 b 2321
2 a 4234
Now what can be the simplest query to remove all the records from T1 which are also present in T2 having the same values of both the columns Col1 and Col2. For example 1-a combination is present in T2 so it should be removed from T1 whereas 1-b should not be removed from T1.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: