Account Number FROM Retrieve Account Number WHERE [Sales_Lead].[dbo].[Sales_Import]. Lead ID) I think there is no need for the inner join.
The first syntactical form, called a searched update, updates the value of one or more columns for all rows of the table for which the WHERE clause evaluates to TRUE.
The SQL UPDATE Query is used to modify the existing records in a table.
You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected.
I have a database with account numbers and card numbers.
I match these to a file to update any card numbers to the account number, so that I am only working with account numbers.
This can also be used to change the column to NULL if the column has no default and is defined to allow null values.