i have two tables, i want a query to retrieve records available in (Instance 1) Table : A and missing in (Instance 2) Table :B.
Table_1: ID | CHARACTER
Tabe_2 : ID | CHARACTER
Output should be :
select * from Table_1 T1
LEFT join [SHH05\SVR1].Students.dbo.Stud_info T2
but am not getting the exact result, can u please help me...