3
Answers

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

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)