SQLite Forum

Docs / Simple SELECT statement (formed via VALUES) and WITH clause
Login
Hello, everyone!

[Documentation page](https://www.sqlite.org/lang_select.html) about `SELECT` statement in the overview section of `select-stmt` says that:

> Note that there are paths through the syntax diagrams that are not allowed in practice. Some examples:
> A VALUES clause can be the first element in a compound SELECT that uses a WITH clause, but a simple SELECT that consists of just a VALUES clause cannot be preceded by a WITH clause.

But i didn't quite get the last case:

> but a simple SELECT that consists of just a VALUES clause cannot be preceded by a WITH clause

Should it be a syntax error? Or this statement (`WITH` + `VALUES`) just makes no sense? 
I've tried to reproduce:

```
sqlite> WITH t(c) AS (SELECT 5) VALUES((SELECT * FROM t),2,3);
5|2|3
```
sqlite3 version:
```
~$ sqlite3 -version
3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1
```
Seems like it's possible to form that kind of statement.
Can someone please help me to clarify ?

Thanks in advance.