On 7/14/05, Brass Tilde <[EMAIL PROTECTED]> wrote:
>>> 'Twere me, I'd do it like this:
>>>
>>> delete timeline
>>> from del_timelines
>>> where timeline.name = del_timelines.name
>>> and timeline.lastchange <= del_timelines.last_change
>> I guess you mean ... from timeline,del_timeline ...
> No, I meant what I wrote, except for the difference in
> "lastchange" to "last_change".
>
>> But regardless, this form of the DELETE command does not (seem)
>> to work in SQLite. Perhaps it is not part of the SQL standard.
> That's quite possible. I didn't test it using SQLite, but that
> form *does* work on MS SQL Server.
Neither is valid SQL. MySQL's is wrong, as is SQLServer's. They're
convenience for people who don't know SQL otherwise.
-austin
--
Austin Ziegler * [EMAIL PROTECTED]
* Alternate: [EMAIL PROTECTED]
