cancel
Showing results for 
Search instead for 
Did you mean: 

Invalid ColOffset while update

adambs
Explorer
0 Kudos

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 -

  1. If i am using IN parameter then it is working
  2. If i am removing B.PC then it is working with NOT IN parameter also

Any help would be appreciated.

Accepted Solutions (0)

Answers (0)