Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Jul 2004 @ 12:57:04 GMT


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


Subj:   Re: Inner joins and missing data
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 30, 2004 08:54 -->

Determine which table will drive the process (always have data), then use OUTER joins to the other tables. Depending on the relationships between the tables, you may end up needing to slap a coalesce statement in the select to ensure proper data presentation (especially if you don't have a "true" driver table..



     
  <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: 15 Jun 2023