I have two linked tables Table1 and Table2. I have deleted some rows in table1
Now I need two delete the rows in table2 that correspond to the rows
deleted in table1. The two table are linked by field id.
I tried the following but with no success:
delete * from table2 where not exists (select * from table1 where
Any help much appreciated.
pgsql-docs by date
|Next:||From: Oliver Elphick||Date: 2001-01-05 15:01:35|
|Subject: Re: nested query |
|Previous:||From: Ron Chmara||Date: 2001-01-05 10:37:32|
|Subject: Re: [GENERAL] RE: RE: Re: MySQL and PostgreSQL speed compare|