|
Archives of the TeradataForumMessage Posted: Wed, 29 Aug 2012 @ 19:54:55 GMT
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
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||