Access 97 Need help with creating a select query

[BCONNER]

I have names in two tables that I need to compare. I just need to print records where the names are different. The tables are linked on ID number. For example For ID1 I need to know if the name is different:<br>
Table 1 Table 2<br>
ID 1 Simth,John ID1 Smith,John M<br>
<br>
How would you create a query to do this?<br>
<br>
<br>
Thanks

 

[Jonathan]

SELECT Table1.ID1, Table1.Name, Table2.Name FROM Table1, Table2 WHERE Table1.ID1 = Table2.ID1 AND NOT (Table1.Name = Table2.Name);<br>
<br>
Will display the ID and Name from table 1 and the name from table 2 where they are different.<br>
<br>
Jonathan