SQL Querie Question!

[meepy]

I want to update the Item_template set the BuyPrice to 0 from Npc_vendor where Entry is 180042 and the Item is Wild

Any ideas?

[Linkn]

You want to change the buy price? You could do this manually easily, find the item (entry 180042) scroll over and change buy price to 0. Remove the item from vendor then re-add it. I may have misunderstood the question so correct me if your attempting something different