3
Answers

Query to find exact row from Table1 which are not available in Table2

rahul kumar

rahul kumar

3y
619
1

Table1

MarketID  Employee ID

101            501      

102            502

103            503

104            504

105            505

 

Table2

MarketID  Employee ID

101             501      

102             502

103             504

106            505

107            507

 

Expected Output:

MarketID  Employee ID

103            503

104            504

105            505

I want to prepare a sql query to find exact full row data from table1 which are not available in Table2.

Answers (3)