Re: Table lookup function in isql?

Posted in 1992

Dave Snyder — 7 Apr 92 17:11:50 GMT — source: Informix-list mailing list archive (1991-1998)

In article <62980009@col.hp.com>, judym@col.hp.com (Judy Miller) writes: > Question: Is there some kind of table lookup feature in isql > (Informix SQL Query Language)? > > Problem: I have a list of keys to 4000 records which I need to delete from > a table of 12000. Assuming you used a SELECT statement to get your list... try: DELETE FROM tabname WHERE colname IN (SELECT colname FROM tabname WHERE contition) you're original select --^ DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.4 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com