有两张表A和B,关联字段为Barcoder,现在要把A表中的AutoID更新到B表中的IDMain中,请写出SQL更新语句
A:
AutoID BarCoder
1 12345
2 56789
B:
IDMain BarCoder
null 12345
null 12345
null 12345
null 56789
null 56789
A:
AutoID BarCoder
1 12345
2 56789
B:
IDMain BarCoder
null 12345
null 12345
null 12345
null 56789
null 56789
UPDATE B
SET B.IDMain = A.AutoID
WHERE B.BarCoder =A.BarCoder
SET B.IDMain = (SELECT A.AutoID FROM A WHERE B.BarCoder = A.BarCoder )
commit;
UPDATE B
SET B.IDMain = nvl((SELECT A.AutoID FROM A WHERE B.BarCoder = A.BarCoder ),-1)