sql 2000 standard edition

Thanks for the replies.

Productid is unique. I will always be returning multiple records. Maybe for production i should just create another table [not temp] and query off that?...

works great. thanks alot

Sorry, I meant for Select. For example, if i have three records each with a shortsku value of 10006, i want to be able to select only one of...