I just imported a new catalog of items to our database using EMS import, were newly insterted and some were updated. The problem I'm having is getting the supplier cost to update for the items that were in already and adding the new items to the supplierlist table. I imported the SupplierID to the Item table just can't figure out the query to go the other way updating and adding new. Any help would be great.
- posted
16 years ago