update table with the boundaries in another

[focus72050]

I have two tables, Inventory and Items

The Inventory table has
Qty_Min and Qty_Max

The Item Table has
Vendor_ID

I want to
Update Inventory
Set Qty_Min = 1 , Qty_Max = 3
Where Vendor_ID (from Items Table) = 'rdc'
thanks in advance guys

 

[LKBrwnDBA]

You need a means to join vendors to items, therefore the items table must have a foreign key to vendors (like vendor number), then it is easy to construct your update:

Update Inventory I
   Set Qty_Min = 1 , Qty_Max = 3
 Where I.Vendor_Nbr IN (  
    Select V.Vendor_Nbr
      From Vendors V
     Where Vendor_ID = 'rdc');

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[rac2]

The syntax may vary for different database brands.

Is there a key that can be used to JOIN the Inventory and Item table?