Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Aug 2012 @ 19:54:55 GMT


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


Subj:   Help needed in writing SQL
 
From:   Verma, Pawan

Hi,

I have some random records which are not present in any table like below :

     (1111,023343,4563,47777,50000,609876,007875,8098765,87009)

I want to check whether these records are present in the table in column name col1 and want to retrieve the records which are not present in the same table from the list.

I can write a left join if these random records are in the table, but my contraint is that I cannot create any type of table as its active production.

For your information , these are just sample records, actually i have to check some 1991 records.


Thanks,

Pawan



     
  <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