Date:         Thu, 28 Nov 2002 19:43:44 GMT
Reply-To:     sf <kgb@KOLUMBUS.FI>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sf <kgb@KOLUMBUS.FI>
Organization: Sonera corp Internet services
Subject:      Simple sql update clause

Hi,

How to implement this simple update clause using SAS tables. I have not
found any examples of multiple columns update.




update ORDERS o
   set(
    cust_name              ,
    order_nr               ,
    item                   ,
    orderr_qty             ,
    order_enter_date
 )
    =
  ( select c.customer_nm    ,
           c.sales_order_nr ,
           c.item_nr        ,
           c.order_qt       ,
           c.order_date
     from customer c
     where (o.order_nr = c.sales_order_nr)
          and (o.item  = c.ITEM_NR)
    )
   where exists
        (select 'x' from customer c
         where (o.order_nr = c.sales_order_nr)
           and (o.item     = c.ITEM_NR)
    )