Thanks, I understand the issue but I was thinking if the record exists in both tables and the Clerk ID and Asset Value does not match then do the update....

Thanks for the response!

Sorry my bad, Badge ID is he Employee ID.

Take these two rows:

INSERT dbo.Source2(EmployeeID, ClerkID) Values(123456, 'abcd');

INSERT dbo.Target2(EmployeeID, AssetValue) VALUES(123456, 'abcd');

yes, no update

INSERT dbo.Target2(EmployeeID, AssetValue) VALUES(123456,...

Sorry, I meant the EmployeeID and not EmployeeBadgeID.

The EmployeeBadgeID in the Employee and the BadgeID in the Assets table are related.

Sorry about the confusion.

1 Records in both tables have changed then:

Employee ...

Thanks I tried this but I want to see records from both tables together.

1. changes to both tables - show records from both table as a single row...