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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
