Archives of the TeradataForum

Message Posted: Fri, 06 Sep 2002 @ 14:28:52 GMT

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

The query is all-AMP because there is no WHERE clause in your select statement. To make this a single amp query you need to add something like

"WHERE nupi_const_f = < a known value >"

Dave

Ward Analytics Ltd: Information in motion
( www.ward-analytics.com )

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