I need to update this table in SQL Server 2005 with data from its 'parent' table, see below:
id (int) udid (int) assid (int)
id (int) assid (int)
sale.assid contains the correct value to update
What query will do this? I'm thinking a
join but I'm not sure if it's possible.