Re: BUG #2789: problem with delete statement

On Tue, Nov 28, 2006 at 00:21:27 +0000,
Lucian Capdefier <luciancapdefier(at)gmail(dot)com> wrote:
>
> 1. I cannot user table alias in the FROM clause of the DELETE statement.

That isn't in the SQL spec, but the extension to allow it has been added
to 8.2 which will be released very shortly.

> 2. I cannot user more than one, table in the FROM clause.

The FROM clause lists the (single) table that rows are to be deleted from.
If you want to join to other tables you should use the USING clause.
USING was added a release or two ago, so if you have a really old release,
if might not be available there. The solution in that case is to take
advantage of the "missing from" feature and just use the table without
giving the table name in a FROM or USING clause.

For questions like this you are going to be better off asking on the
general or novice lists instead of bugs. Less people are going to see
the message on the bugs list, so you are less likely to get help with
posts there.