Hi, given the following tables:
CREATE TABLE table_1(id INTEGER PRIMARY KEY,column VARCHAR(64));
CREATE TABLE table_2(id INTEGER PRIMARY KEY,column VARCHAR(64));
I realized that the following query isn't valid in SQLite:
SELECT *
FROM
(
table_1
INNER JOIN
(
SELECT *
FROM table_2
WHERE column = 'whatever'
) AS inner_1
ON table_1.id = inner_1.id
);
It returns error message:
SQL error: near "table_1": syntax error
But if I write it like that it works just fine:
SELECT *
FROM
table_1
INNER JOIN
(
SELECT *
FROM table_2
WHERE column = 'whatever'
) AS inner_1
ON table_1.id = inner_1.id
;
It also works fine if I write the query like that:
SELECT *
FROM
(
select * from table_1
INNER JOIN
(
SELECT *
FROM table_2
WHERE column = 'whatever'
) AS inner_1
ON table_1.id = inner_1.id
);
To me the first query should be valid. it seems the SQL engine desn't
like having a table name right after an opening parenthesis. Are there
any standards regarding parenthesis in SQL92?
Thank you
Simon B.
