Re: SQL Problem - Trying to update a table with data from another tab le

["Batchelor, Mildred @ HFS" <MBATCHELOR@CKR.COM>]

Thanks all:

I have it working.  This is what I did as follows:

Update PS_BU_ITEMS_INV

  set  PS_BU_ITEMS_INV .QTY_RESERVED =  (SELECT qty_allocated
                                                                        FROM
c_ps_sum1_demandin B
                                                 WHERE
PS_BU_ITEMS_INV.BUSINESS_UNIT = B.BUSINESS_UNIT
                                                        and
PS_BU_ITEMS_INV.INV_ITEM_ID = B.INV_ITEM_ID)
        WHERE EXISTS  (SELECT 'X' FROM c_ps_sum1_demandin C
                                                WHERE
PS_BU_ITEMS_INV.BUSINESS_UNIT = C.BUSINESS_UNIT
                                                        and
PS_BU_ITEMS_INV.INV_ITEM_ID = C.INV_ITEM_ID);

Mildred Batchelor
mbatchelor@ckr.com