Archives of the TeradataForum

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

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

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>>