Re: Add Missing From?

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.

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

-- 
Josh Berkus
Aglio Database Solutions
San Francisco