I need to update this table in SQL Server with data from its 'parent' table, see below:
sale.assid contains the correct value to update ud.assid.
If you want to unleash your potential in this competitive field, please visit the SQL course page for more information, where you can find the SQL tutorials and SQL frequently asked interview questions and answers as well.
This topic has been locked/unapproved. No replies allowed