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.

Thanks for your help.

-tom

• Next in forum: Re: min(date) + 1
• Prev in forum: Re: Help finding the top 3 zipcodes within the top 5 counties
• Thread view: Re: Syntax to add records if primary key = list

[Reply to this message]