Re: [ADMIN] query on multiple tables in schema

2004-10-01 Thread Bruno Wolff III
On Tue, Sep 28, 2004 at 17:19:20 -0400, Angus Berry <[EMAIL PROTECTED]> wrote: > Hi, I wonder if anyone can help. > > I'd like to execute a SQL query that performs an action on all the > (unrelated) tables that I select. The following query doesn't work, but > the subselect (which works) shows w

[ADMIN] query on multiple tables in schema

2004-10-01 Thread Angus Berry
Hi, I wonder if anyone can help. I'd like to execute a SQL query that performs an action on all the (unrelated) tables that I select. The following query doesn't work, but the subselect (which works) shows what I'm trying to do. All tables have an identical column called id_num. delete from (sel