Archives of the TeradataForum

Message Posted: Thu, 22 Apr 2004 @ 21:02:10 GMT

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

This is because you are setting two tables in one instance. Try using like

     Update tabele01 t1
     Set x1 = select x2 from table02 t2 where t1.pk1 = t2.pk1
     ;

This should solve your problem

Thanks

Hari Pattisapu
Metrics and Reporting

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