how to update data from two tables if the value is the same

Question

I have two tables in both tables have a BSONUM column, I need to update table1 column REIS if in both tables BSONUM = BSONUM

made a query in SQL Server but does not work

Does this answer your question? [Update a table using JOIN in SQL Server?](https://stackoverflow.com/questions/1604091/update-a-table-using-join-in-sql-server) — Suraj Kumar, Jan 23 '20 at 11:32

score 1 · Accepted Answer · answered Jan 23 '20 at 11:30

1

You can do join & always define table alias:

update t
     set t.reis_t = s.reis
from ticket t inner join
     segements s
     on s.bsonum = t.bsonum;

answered Jan 23 '20 at 11:30

Yogesh Sharma

49,870
5
26
52

score 0 · Answer 2 · answered Jan 23 '20 at 11:32

Apperently there is ambiguity in the column name BSONUM Have you tried doing WHERE FirstTable.BSONUM = SecondTable.BSONUM

If you have two columns with the same name from two tables the engine has issue understanding which one you are referring to. Thus, you need to specify table name as well.

how to update data from two tables if the value is the same

2 Answers2