我有桌子: List_of_payment,payment_tbl,foods_tbl,drinks_tblbill_id | year | owner_IDjoin List_of_payment on payment_tbl.bill_id = List_of_payment.bill_id
where year in (select year fromList_of_payment where owner_id ='
保存了正确的值,正如您所看到的,这两个表几乎相同,我只需要从payment.TransactionCode中移动所有数据并替换为payment2.TransactionCode。FROM payment ON payment.Id = payment2.IdUPDATE payment
SET payment<