Archives of the TeradataForum

Message Posted: Wed, 28 Apr 2004 @ 09:29:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

     update x_olap.tbl1
     from (
            Select
                   plantypeid,
                   memid,
                   monthid
            From
                   y_dev.tbl2 ) As T2 (plantypeid_t, memid_t, mothid_t)
        set
              plantypeid = T2.plantypeid_t
        where
                memid = T2.memid_t And
        monthid = T2.monthid_t;

	<Prev	Next>		<<First	<Prev	Next>	Last>>