Update table with join.
We have two table with name s1
and s2
In first table s1 we have add1
column with null value.
We have another table s2 that
contains loc column . Now we need a sql query to update table s1 add1 column
with second s2 loc column.
Table name s1
id Name add1
1 Rahul NULL
2 Ramu ...
