Re: Table lookup function in isql?

>>Problem: I have a list of keys to 4000 records which I need to delete from >> a table of 12000. >> >>I'm trying to avoid writing a program for this common function. >>(I do not have 4GL on this machine, but I do have ESQL/C.) > >Try this one: >1. load the key list into a (temporary) table > (create table, load from .. etc.) >2. Then delete records by executing: > delete from orig_table > where key_field in ( select * from temp_table )> >3. Then drop key list, if not created by create temp table .. Thanks for this and all email responses. This is the obvious solution ... welcome to the relational database world. Judy