Joined deletes but one table being a subquery.

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Joined deletes but one table being a subquery.
Date: 2003-08-22 10:01:13
Message-ID: 200308221531.13782.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi Folks,

DELETE from eyp_listing where userid=t_a.userid and category_id=t_a.category_id;
such queries work perfectly.

but if t_a is a subquery how to accomplish the delete.

Regds
Mallah.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-08-22 10:23:42 Re: Joined deletes but one table being a subquery.
Previous Message Tomasz Myrta 2003-08-22 06:42:13 Re: date calculation