Consider the following dataset
create table #t1(id int, amount money) create table #t2(id int, tamount money) insert into #t1(id,amount) select 1,10 union all select 2,20 union all select 3,30 insert into #t2(id,tamount) select 1,55 union all select 2,44
Now consider the following UPDATE statement
update #t1 set amount=tamount from #t2
What do you think the result is? How does this UPDATE work despite not relating the tables #t1 and #t2?