关于SQLite创建视图，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]
执行成功，错误点：表别名.字段名 改为 表别名.[字段名]，即将字段名放入方括号中。就这一点点问题，郁闷。