On 17 Jan 2016, at 12:27am, R Smith <rsmith at rsweb.co.za> wrote: > I quote from the documentation at: https://www.sqlite.org/lang_with.html > > "All common table expressions (ordinary and recursive) are created by > prepending a WITH clause in front of a SELECT, INSERT, DELETE, or UPDATE > statement. A single WITH clause can specify one or more common table > expressions...."
Ah, I missed that. I thought it was just SELECT. Thanks. Simon.