Skip site navigation (1) Skip section navigation (2)

nested query

From: Mustapha Amrani <ma10024(at)newton(dot)cam(dot)ac(dot)uk>
To: pgsql-docs(at)postgresql(dot)org
Subject: nested query
Date: 2001-01-05 14:04:06
Message-ID: 200101051404.OAA16359@laplace (view raw or flat)
Thread:
Lists: pgsql-docs
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
table2.id=id);

Any help much appreciated.

Mustapha


pgsql-docs by date

Next:From: Oliver ElphickDate: 2001-01-05 15:01:35
Subject: Re: nested query
Previous:From: Ron ChmaraDate: 2001-01-05 10:37:32
Subject: Re: [GENERAL] RE: RE: Re: MySQL and PostgreSQL speed compare

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group