Transformer
05-17-2013, 12:32 AM
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?host=usefulgyaan.wordpress.com&blog=50473542 &post=715&subd=usefulgyaan&ref=&feed=1
Excluding Records of one Table from the Other Table (http://usefulgyaan.wordpress.com/2013/05/16/excluding-records-of-one-table-from-the-other-table/)
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?host=usefulgyaan.wordpress.com&blog=50473542 &post=715&subd=usefulgyaan&ref=&feed=1
Excluding Records of one Table from the Other Table (http://usefulgyaan.wordpress.com/2013/05/16/excluding-records-of-one-table-from-the-other-table/)