Archives of the TeradataForum

Message Posted: Wed, 28 Apr 2004 @ 09:47:11 GMT

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

use this:

     update x_olap.tbl1 T1
     set plantypeid = y_dev.tbl2.plantypeid
     where T1.memid = y_dev.tbl2.memid
       and T1.monthid = y_dev.tbl2.monthid;

Regards

Rishi

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