> 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.
What kind of subquery it is? Exist/Not exist doesn't work?
In response to
pgsql-sql by date
|Next:||From: Michele Bendazzoli||Date: 2003-08-22 11:59:54|
|Subject: Bug on parameter bigint in PL/PGSQL|
|Previous:||From: Rajesh Kumar Mallah||Date: 2003-08-22 10:01:13|
|Subject: Joined deletes but one table being a subquery.|