update b set b.idex=a.idex from table2 b inner join table1 a on a.id=b.id
update tabel2 set idex=table1.idex from table1 where table2.id=table1.id
update table2 set idex=a.idex from table2 as b join table1 as a on a.id=b.id
update table2 set table2.idex=table1.idex from table1 join table2 on table1.id=table2.id
update table2 set idex=a.idex from table1a where id=a.id
--少個空格 update table2 set idex=a.idex from table1 a where id=a.id
update table2 set table2.idex=table1.idex from table2, table1 where table2.id = table1.id
update table2 set table2.idex=table1.idex from table2,table1 where table2.id=table1.id
update b set b.idex=a.idex from table2 b inner join table1 a on a.id=b.id
UPDATE SET table2.idex = table1.idex FROM table2 JOIN table1 ON table2.id = table1.id
UPDATE table2 SET table2.idex = table1.idex FROM table2 JOIN table1 ON table2.id = table1.id
update b set b.idex=a.idex from table2 b inner join table1 a on a.id=b.id
update table2 set table2.idex=table1.idex from table2, table1 where table2.id = table1.id
update b set b.idex=a.idex from table2 b inner join table1 a on a.id=b.id
update table2 set table2.idex=table1.idex from table2, table1 where table2.id = table1.id
UPDATE table2 SET table2.idex = table1.idex FROM table2 INNER JOIN table1 ON table2.id = table1.id
update b set b.idex=a.idex from table2 b inner join table1 a on a.id=b.id update table2 set table2.idex=table1.idex from table2, table1 where table2.id = table1.id那种写法更好一点呢?
from table2 b
inner join table1 a
on a.id=b.id
set idex=table1.idex
from table1
where table2.id=table1.id
update table2 set idex=a.idex
from table2 as b join table1 as a
on a.id=b.id
update table2 set table2.idex=table1.idex from table1 join table2
on table1.id=table2.id
from table1a where id=a.id
update table2 set idex=a.idex
from table1 a where id=a.id
update table2 set table2.idex=table1.idex from table2, table1 where table2.id = table1.id
set table2.idex=table1.idex
from table2,table1
where table2.id=table1.id
set b.idex=a.idex
from table2 b
inner join table1 a
on a.id=b.id
UPDATE SET table2.idex = table1.idex
FROM table2 JOIN table1 ON table2.id = table1.id
UPDATE table2 SET table2.idex = table1.idex
FROM table2 JOIN table1 ON table2.id = table1.id
from table2 b
inner join table1 a
on a.id=b.id
set table2.idex=table1.idex
from table2, table1
where table2.id = table1.id
from table2 b
inner join table1 a
on a.id=b.id
set table2.idex=table1.idex
from table2, table1
where table2.id = table1.id
UPDATE table2
SET table2.idex = table1.idex
FROM table2
INNER JOIN table1 ON table2.id = table1.id
from table2 b
inner join table1 a
on a.id=b.id
update table2
set table2.idex=table1.idex
from table2, table1
where table2.id = table1.id那种写法更好一点呢?