The two table contains same data , but there could be missing rows

Row - Number- Row number
Company - Number - which is same for all the data
Loc - Text - changes for some records
EmpNo - Number - changes for some records
Key - unique key would be combination of set of some fields given below
Company + Loc + Empno+ StartDate
Table1
Row, Company, Loc, EmpNo, EmpName, BenType, Plan, StartDate, stopDate
1 4321 MN 1000 a X A date1
2 4321 MN 1000 a X B date2 date3
3 4321 MN 1000 a X B date5
( 3- Missing record in Table 2)
4 4321 SC 1010 b Y C date4

Table2
Row, Company, Loc, EmpNo, EmpName, BenType, Plan, StartDate, stopDate
1 4321 MN 1000 a X A date1
2 4321 MN 1000 a X B date2 date3
3 4321 SC 1010 b Y C date4

Note that Row is different

What could be the SQL query to retrive the data from table 1 which is present in table1 and missing in table 2

Thanks and Regards
Lawson, COBOL

__________________
Thanks and Regards
Lawson, COBOL

Use the Query Wizard and create a "Find Unmatched" query. This will build it for you automatically. It will find those records in Table 1 that have no corresponding record in Table 2, based on some field value (in your case, Row).

This is what the SQL looks like (from Northwind):
(I searched for Customers who do not have a matching name in Employees)

SELECT Customers.CustomerID, Customers.CompanyName
FROM Customers LEFT JOIN Employees ON Customers.ContactName = Employees.LastName
WHERE (((Employees.LastName) Is Null));



mmcdonal