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.

Reply via email to