Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2008 @ 11:39:22 GMT

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

Hi,

There is one typo, we can't use "SET t1.consumer_count = ...." and need to use "SET consumer_count = ....".

I think, you need to provide more information (exact sql, tables structure), Not sure but NULL could be one of the reason.

Thanks.

     UPDATE t1
     FROM
            Table1 t1,
            Table2 t2
     SET
            consumer_count = t2.consumer_count
     WHERE
            T1.table1_id = t2.table1_id;

Best Regards,

Kapil Dev Sapra

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