http://craftydba.com/?attachment_id=5149

Hi SQL Guy,

Unless you try the sample code that I gave you, we really do not know what you are trying to do.

I updated table A to have two records. Table B has one matching record.

After the update, both records in table are updated.

Works like I think it would!

Cheers