No data is updated in the Update statement of the associated subquery. -- Method 1: Update? Table1? Set? C ?? (Select? C? From? Table2? Where? A ?? Table1.a )? Where? C? Is? Null? -- Method 2: update ?? Aset ?? NewqiantityB. qiantityfrom ?? A, Bwhere ?? A. bnumB. bnum? -- Method 3: update ???? (Select? A. bnum ?, A. newq
No data is updated in the Update statement of the associated subquery. -- Method 1: Update? Table1? Set? C? =? (Select? C? From? Table2? Where? A? =? Table1.a )? Where? C? Is? Null? -- Method 2: update ?? Aset ?? Newqiantity = B. qiantityfrom ?? A, Bwhere ?? A. bnum = B. bnum? -- Method 3: update ???? (Select? A. bnum ?, A. newq
Associate a subquery with an Update statement to Update data
<无>
-- Method 1: Update? Table1? Set? C? =? (Select? C? From? Table2? Where? A? =? Table1.a )? Where? C? Is? Null? -- Method 2: update ?? Aset ?? Newqiantity = B. qiantityfrom ?? A, Bwhere ?? A. bnum = B. bnum? -- Method 3: update ???? (Select? A. bnum ?, A. newqiantity, B. qiantity? From? A? Left? Join? B? On? A. bnum = B. bnum )? AS? Cset? C. newqiantity? =? C. qiantitywhere? C. bnum? = XX?