Rachel Curran wrote ...

this brings back all
the gci (primary key) even if no change occurred. So ther are the same
amount of rows in both the tables and query.

Append a WHERE clause to your SELECT query e.g.

SELECT
<<column list
FROM
<<table list
WHERE
T1.DATE_OF_BIRTH < T2.DATE_OF_BIRTH
OR T1.GRADE < T2.GRADE
OR T1.DEPT_DESCR < T2.DEPT_DESCR
OR T1.BUSINESS_SUB_AREA < T2.BUSINESS_SUB_AREA;

Jamie.

--