Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2006 @ 09:36:22 GMT

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

Randall:

You cannot alias the table being modified. Change all lp1 references to the lp_test_table table name. That will eliminate this particular error. However, as I look at this "solution" it would seem that you are going to need a join condition between the derived table and your table being updated. Otherwise you will have a product (cartesian) join and it will not work.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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