Archives of the TeradataForum

Message Posted: Tue, 29 Oct 2002 @ 20:05:22 GMT

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

Just load the data from FoxPro to table and extract the data after you join. I'd use In Clause instead of exists unless the columns include nulls.

This will be the fastest approach.

sel * from teradata where (col1, col2) in (select col1, col2 from

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

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