RE: SQL advice please

Is this a program, or ad hoc sql in dbaccess? How many rows do you expect to delete? How many rows are in table_a and table_b respectively. Will >> From: Steve Barnes [SMTP:sgbarnes99@hotmail.com] >> Sent: Tuesday, February 29, 2000 7:25 AM >> To: informix-list@iiug.org >> Subject: SQL advice please >> >> Morning all and Obnoxio, >> >> I am trying to delete some rows from a table where the same columns exist >> in >> another table, but there are two columns to check. I want to delete all >> rows >> in table_a where col_a and col_b are in table_b. >> >> The only way I have so far is as follows >> >> DELETE FROM table_a WHERE trim(col_a)||trim(col_b) IN >> (SELECT trim(col_a)||trim(col_b) from table_b)>> >> Does anyone know of a better way? >> >> Thanks >> >> Steve >> >> ______________________________________________________ >> Get Your Private, Free Email at http://www.hotmail.com ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------