Thanks (everyone) for the guidance on this. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell)
-----Original Message----- From: Austin Ziegler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 5:01 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] proper SQL DELETE syntax 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]
