关于SQLite创建视图

今天在SQLite中创建视图时，遇着点小麻烦，先把已经做好的SQL2005的创建视图语句直接用于SQLite的视图创建，

--SQL2005中的视图创建语句

CREATE VIEW [dbo].[VIEW_SYS_REGION]
AS
SELECT
Province.Code AS province_CODE, province.name AS Province,
City.Code AS City_Code, city.name AS City,
Area.Code AS Area_Code, area.name AS Area, area.ZipCode AS ZipCode
FROM
 (select * from .dbo.sys_region where level=1) as province
left join
 (select * from .dbo.sys_region where level=2) as city
  on city.parent_code=province.code
left join
 (select * from .dbo.sys_region where level=3) as area
  on area.parent_code=city.code

 

在SQLite中执行结果报错： SQL Error: near ".": syntax error

然后改为

--SQLite中创建视图

CREATE VIEW [VIEW_SYS_REGION]
AS
SELECT
Province.[Code] AS province_CODE, province.[name] AS Province,
City.[Code] AS City_Code, city.[name] AS City,
Area.[Code] AS Area_Code, area.[name] AS Area, area.[ZipCode] AS ZipCode
FROM
 (select * from sys_region where level=1) as province
left join
 (select * from sys_region where level=2) as city
  on city.[parent_code]=province.[code]
left join
 (select * from sys_region where level=3) as area
  on area.[parent_code]=city.[code]

 

执行成功，错误点：表别名.字段名  改为 表别名.[字段名]，即将字段名放入方括号中。就这一点点问题，郁闷。