Postgres Pro
Downloads
Home   >   mailing lists

Joined deletes but one table being a subquery. - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Joined deletes but one table being a subquery.
Date
Msg-id 200308221531.13782.mallah@trade-india.com
Whole thread Raw
Responses Re: Joined deletes but one table being a subquery.
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: date calculation
Next
From: Tomasz Myrta
Date:
Subject: Re: Joined deletes but one table being a subquery.