problem in Updating a column

[Nalwyn]

Hi,

I have a problem in updating a column of table by matching two table of two column.if value of two columns are equal then we have to update the column of one table

[iburyak]

Try this:

Update tableA
Set column = value
From tableA
inner join tableB on tableA.column = tableB.column

Good Luck.

[Nalwyn]

Hi,

Thanks for providing solution in solving the updating problem