SQLite Forum

INNER JOIN error
Login
>No, it does not

sqlite> select [City] AS SBracket,"City" AS DQuotes,'CitySQuotes',"CityDQuotes"   from employees limit 1;

SBracket  DQuotes   'CitySQuotes'  "CityDQuotes"
--------  --------  -------------  -------------
Edmonton  Edmonton  CitySQuotes    CityDQuotes

... the names of the last two columns.

Correction: The CLI DOES allow square brackets; the Dot Commands do NOT.