I need to update reorder and restock based on the mpq listed in the supplier table. I wrote a select to check: select code, item.oreorderpoint, from supplierlist where = then I wrote an update: update item set = 1 from supplierlist where

Your select statement shoul look like this:select from item join supplierlist on and Your update query should look like this:update item set = 1 from item join supplierlist on and where I need to update reorder and restock based on the mpq listed in the supplier

Does this SQL Statement Look Safe to Run?

Sep 01, 2009 1 Replies

Rate this thread:

Chris 16 years ago

I need to update reorder and restock based on the mpq listed in the supplier table.

I wrote a select to check: select item.description, item.itemlookup code, item.restocklevel, item.oreorderpoint, item.id, supplierlist.itemid, supplierlist.masterpackquantity from supplierlist where item.id = supplierlist.itemid

then I wrote an update: update item set item.reorderpoint = 1 from supplierlist where supplierlist.masterpackquantity

Vote

Matt Hurst 16 years ago

Your select statement shoul look like this:

select item.description, item.itemlookupcode, item.restocklevel, item.reorderpoint, item.id, supplierlist.itemid, supplierlist.masterpackquantity from item join supplierlist on item.id=supplierlist.itemid and item.supplierid=supplierlist.supplierid

Your update query should look like this:

update item set item.reorderpoint = 1 from item join supplierlist on item.id=supplierlist.itemid and item.supplierid=supplierlist.supplierid where supplierlist.masterpackquantity I need to update reorder and restock based on the mpq listed in the supplier

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required