I have 2 tables one table lists all the client name.
second table refer has a column with the client name
As you see table 2 has the name of the Client Name in string (varchar(255)
Now i wish to add an additional column to the second table to store the CLIENT_ID
and this client_id column needs to be updated based on the data in the table 1.
Can i do with one Single Update statement.