Reply to Re: Syntax to add records if primary key = list
Posted by tom on 09/22/05 00:53
>UPDATE orders SET ord_freight = 15 WHERE ord_custId IN (1,2,3,4,5)
It seems you got it there - the IN (range) works. I, however, need to
add records, so presumably I will just use the Insert statement in
place of the update.