MYsql视图创建问题

[ljking0731]

下面单独执行没问题

select b.* from
(
select 
a.passWord,a.Phone,a.Branch_id,a.Branch_name, OAID, a.User_name as UserName, ImgIndex, Sign, 
BelongGroup,'' as IP,0 as Port
from TABHZBaZhongUserInfo as a
left outer join TABHZUserInfoCfg as b on a.AutoID=b.OAID where a.AutoID is not null
union all 
select cast(AutoID as CHAR),cast(AutoID+1 as CHAR),999,'群',AutoID+99999,GroupName,315,Remark,
CONCAT(',',cast(AutoID as CHAR),','),
cast(AutoID as CHAR),AutoID+1
from TABHZUserGroupCfg where IsDel=0
) as b
order by branch_id,username LIMIT 800

但是改成视图就出错：

create view view_HZEmployeeInfo
AS
select b.* from
(
select 
a.passWord,a.Phone,a.Branch_id,a.Branch_name, OAID, a.User_name as UserName, ImgIndex, Sign, 
BelongGroup,'' as IP,0 as Port
from TABHZBaZhongUserInfo as a
left outer join TABHZUserInfoCfg as b on a.AutoID=b.OAID where a.AutoID is not null
union all 
select cast(AutoID as CHAR),cast(AutoID+1 as CHAR),999,'群',AutoID+99999,GroupName,315,Remark,
CONCAT(',',cast(AutoID as CHAR),','),
cast(AutoID as CHAR),AutoID+1
from TABHZUserGroupCfg where IsDel=0
) as b
order by branch_id,username LIMIT 800

提示：View's SELECT contains a subquery in the FROM clause

不知是啥问题

[ACMAIN_CHM]

视图中不能再有子查询了。
你可以先创建一个视图，然后再基于这个视图创建新视图试一下。

[雨天要吃饭]

视图貌似不能直接嵌套来创建的。

[rucypli]

语法不能这么写