Re: Add Missing From?

On 8/9/2004 12:53 PM, Josh Berkus wrote:

> People,
>
>> > DELETE FROM target_tbl USING other_tbls WHERE ...
>>
>> Feels much more understandable. The second FROM looks like a hickup.
>
> Yes, although imagine:
>
> DELETE FROM staff USING users JOIN logons USING (user_id)
> WHERE last_logon < ( now() - '6 months');
>
> Not as bad as FROM, but still a bit baffling to look at. Still, I can't
> think of anything else that wouldn't require inventing a new reserved word.

What about

DELETE FROM staff JOIN users ...

then?

>
> Oh, and MySQL's "multi-table deletes": PLEASE tell me that's not
> SQL-standard.
>

Yes, not standard.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #