Re: " Adding missing FROM-clause entry for table .... " problem.

On Tue, Feb 18, 2003 at 12:51:27 +0100, Christoph Haller <ch@rodos.fzk.de> wrote:
> AFAIK, statements like
> 
> DELETE FROM t1 where t1.id = t2.id ;
> 
> are legal. Could the parser still work on this, if the feature is
> removed?

Only if a new syntax is added.

In fact it would be nice if this automatic adding of join tables was documented
under delete. Most people aren't going to notice that the optional listing
of joined tables mentioned under the select documenation applies to delete.
And if people don't notice they are likely to try to implement this using
subselects which may not be as efficient in some cases.