Excluding Records of one Table from the Other Table

UsefulGyaan Has Posted the Following On 05-16-2013 09:00 PM:

Problem Statement:*There are two tables and we need to get all the records from Table1 that are not in Table2. Table1 Table2 Emp_id Salary Emp_id Name 1 10000 1 Tom 2 23000 2 Rock 4 40000 3 Thor 9 34000 Solution: It can be done in two ways, using Left Join OR using Exists condition. […]http://stats.wordpress.com/b.gif?hos...f=&feed=1





Excluding Records of one Table from the Other Table