Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 12 Jun 2003 @ 17:03:57 GMT

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

Subj:   Re: What's up with NOT IN?
From:   Markus Unterguggenberger

Could it be that Vendor_id is NULL for some entries in ETL_TEMP.XREF_VENDOR or in ETL_TEMP.XREF_VENDOR_TMP, because then the query has problems

Maybe changing the subquery to

where Vendor_id is not NULL
group by 1)

helps. If you check this I would appreciate to hear if it worked?`

Hope it helps


  <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: 27 Dec 2016