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

Alok pandey5y ago

Accepted answer

Hi Rahul Kumar,

I think it will help you.

select t.* from Table1 as t where not exists(

select 1 from Table2 as t2

where t.marketId=t2.marketId and t.EmployeId=t2.EmployeeId)

satheesh d4y ago

Select * from table_1 Select * from table_2

Lets take these two tables, by comparing these two tables, the 106 and 107 records in table1 are the unique records that are not avilable in the table2. In order to find the distinct record in table1,

Select t1.* from Table_1 t1 left outer join Table_2 t2 on t1.MarketId=t2.MarketId where t2.EmployeeId is null;

Basem Alshabani5y ago

Select * from table1 left join table2 on table1.marketid =table2.marketid where table2.marketid is null