rahul kumar

rahul kumar

  • 2k
  • 144
  • 741

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

Aug 7 2021 4:51 AM

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)