Hi friends

i have two Ms access database files with same structure and same data

Example

File 1

Row (Key) SSN Tax Salary Gross
1 3 6 7 9
2 4 6 8 10
Missing record---------------------


File2
Row (Key) SSN Tax Salary Gross
1 3 5 7 9
2 4 6 8 10
3 11 12 13 14

Note : In file1 first row the value of tax are different

My SQL query is
--------------------------------------------------------------------
SELECT
File2.row, File2.SSN, File2.QtrTxbl, File2.QtrTxbl, File2.YtdTxbl, File2.QtrAmt, File2.YtdAmt, File2.QtrGross, File2.YtdGross

FROM File2 LEFT JOIN File1 ON File2.SSN=File1.SSN

WHERE (((File1.SSN) Is Null));

--------------------------------------------------------------------

I want Qury to return only 3rd record in file2 as that one is Null in file1 (missing in file1 but present in file2)

The problem is its retrieving first row and the missing record too

Can anyone help me with this?

Thanks and Regards
Lawson, COBOL

__________________
Thanks and Regards
Lawson, COBOL