I could really use some help with this one! I need an SQL statement that will insert a second supplier into the item properties of over 16,000 items- the entire contents of the Item table. This second supplier is to be the primary supplier with a reorder number thats the same as the item lookup code and a cost price of zero. I'm not too sure how to proceed as I think we're talking the SupplierList table and the Item table. Any advice would be appreciated! The exact statement would win the provider my eternal gratitude!
- posted
16 years ago