Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Using teradata table and front end tool
 
From:   Kohut, Eric J

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020