Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Jun 2003 @ 17:08:45 GMT


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


Subj:   Re: What's up with NOT IN?
 
From:   Jason Fortenberry

Peter,

Why does the count of your left outer join return less than the number of rows in ETL_TEMP.XREF_VENDOR_TMP? The left outer join is basically the same thing as count(*) from this one table, so I do not think it should have returned 3993 but instead have 231226.

Also, your table DDL says columns not null, but your left join has "WHERE F.VENDOR_ID IS NULL".

Why/how is this?

As suggested, I am thinking you have nulls somehow in your data as this might explain some of your results. Could you modify your "NOT IN" sql statement to add WHERE XREF_VENDOR.VENDOR_ID IS NOT NULL to the derived query part.

--Jason



     
  <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