select * from strlib/amagusr a inner join strlib/amagusr b  
on a.AUGROUP = b.AUGROUP                                    
where a.AUGUSER <> b.AUGUSER                                


UPDATE tblTest2 INNER JOIN tblTest1 
ON tblTest2.PersonID = tblTest1.PersonID 
SET tblTest2.LastName = [tblTest1].[LastName]
WHERE (((tblTest2.LastName)<>[tblTest1].[LastName]))