There's not really a way to do exactly this in SQL Data Compare - I guess we'd recommend that you first update Table1 from the source database so that you can be sure to maintain referential integrity?

Alternatively, you could create a view containing all the important fields in both databases and compare that? Do either of those options sound practicable in your environment?