on 03-11-2022 8:02 AM
update TargetTable
set ItemQty = null
where (ItemID, ItemNb, PC, ItemQty) NOT IN
(SELECT A.ItemID, A.ItemNb, B.PC, A.ItemQty FROM Table1 as A
inner join
Table2 as B on A.ItemID = B.ItemID)
Error - sql processing error: invaild ColOffset for A.ItemID
Note -
Any help would be appreciated.
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.