Beginner Access 2000 Query Question

I am trying to compare 2 tables in a mdb. One table is a linked xls file. Lets call it table A. The other is a standard table. Lets call it table B.

Table A is the "old" data that may need updated. Table B is the brand new data that will always be correct.

I want to find the differences in table B from table A. Keying off one field (ASSET_TTAG and T_TAG) if any of the attributes (8 attributes) of a record in table B are different from that matching record in table A then that record needs to be updated.

Also, if a record in table B is not in table A that will need updated also.

All of these discrepancies need to be displayed in a query along with all the attributes.

LCAMdump = Table A, SCANDATA_tbl = table B

SELECT SCANDATA_tbl.ASSET_TTAG, SCANDATA_tbl.BUILDING_NAME, SCANDATA_tbl.FLOOR, SCANDATA_tbl.DESK, SCANDATA_tbl.COLUMN, SCANDATA_tbl.FNAME, SCANDATA_tbl.LNAME, SCANDATA_tbl.SSO
FROM SCANDATA_tbl LEFT OUTER JOIN LCAMdump ON SCANDATA_tbl.ASSET_TTAG = LCAMdump.T_TAG;

That is what i have so far. But it is returning a test record that i know is the same in both therefor should not be listed. :confused:

SELECT SCANDATA_tbl.ASSET_TTAG, SCANDATA_tbl.BUILDING_NAME, SCANDATA_tbl.FLOOR, SCANDATA_tbl.DESK, SCANDATA_tbl.COLUMN, SCANDATA_tbl.FNAME, SCANDATA_tbl.LNAME, SCANDATA_tbl.SSO
FROM SCANDATA_tbl INNER JOIN LCAMdump ON SCANDATA_tbl.ASSET_TTAG = LCAMdump.T_TAG
WHERE ((([SCANDATA_tbl]![USER _ID])<>[LCAMdump]![USER_LOGIN])) OR (((SCANDATA_tbl.BUILDING_NAME)<>[LCAMdump]![BUILDING])) OR (((SCANDATA_tbl.FLOOR)<>[LCAMdump]![FLOOR])) OR (((SCANDATA_tbl.DESK)<>[LCAMdump]![DESK])) OR (((SCANDATA_tbl.COLUMN)<>[LCAMdump]![COLUMN])) OR (((SCANDATA_tbl.FNAME)<>[LCAMdump]![USER_FIRST])) OR (((SCANDATA_tbl.LNAME)<>[LCAMdump]![USER_LAST])) OR (((SCANDATA_tbl.SSO)<>[LCAMdump]![LOGIN_SSO]));

I have also tried this but it is not quite what i am looking for. :(
Not sure how hard this is, at first it did not seem like a difficult query but i am not getting anywhere fast.

Any help would be great.