1 2 3
|
UPDATE [TableB] SET [TableB].F1 = (SELECT TableA.F1 FROM TableA), [TableB].F2 = [(SELECT TableA.F2 FROM TableA), [TableB].F3 = (SELECT TableA.F3 FROM TableA), [TableB].F4 = (SELECT TableA.F4 FROM TableA), [TableB].F5 = (SELECT TableA.F5 FROM TableA), [TableB].F6 = (SELECT TableA.F6 FROM TableA), [TableB].F7 = (SELECT TableA.F7 FROM TableA), [TableB].F8 = (SELECT TableA.F8 FROM TableA), [TableB].F9 = (SELECT TableA.F9 FROM TableA), [TableB].F10 = (SELECT TableA.F10 FROM TableA), [TableB].F11 = (SELECT TableA.F11 FROM TableA), [TableB].F12 = (SELECT TableA.F12 FROM TableA), [TableB].F13 = (SELECT TableA.F13 FROM TableA), [TableB].F14 = (SELECT TableA.F14 FROM TableA), [TableB].F15 = (SELECT TableA.F15 FROM TableA), [TableB].F16 = (SELECT TableA.F16 FROM TableA), [TableB].F17 = (SELECT TableA.F17 FROM TableA), [TableB].F18 = (SELECT TableA.F18 FROM TableA)
WHERE (((TableB.F11)=(SELECT TableA.F11 FROM TableA WHERE TableB.F11 = TableA.F11))); |
Partager