问题1：
[SQL] CREATE
VIEW `EisUserView`AS
SELECT EisUser.SerialNumber, EisUser.UserID, EisUser.UserName, EisUser.IC, REPLACE(REPLACE(EisUser.Sex, 'M', '男'), 'F', '女') AS Sex,
[Group].UpperGroupID AS DeptID, EisUser.GroupID, '../App_HeadFace/' + EisUser.HeadFace + '_s.gif' AS HeadFaceImageUrl, EisUser.RegTime,
EisUser.LoginTime, EisUser.State
FROM EisUser LEFT OUTER JOIN
[Group] ON EisUser.GroupID = [Group].GroupID
WHERE (EisUser.UserID <> 'administrator');
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Group].UpperGroupID AS DeptID, EisUser.GroupID, '../App_HeadFace/' + EisUser.He' at line 4
这样的样式应该怎么写才可以。
问题2：
子查询的写法
[SQL] CREATE
VIEW `Erp_All_User_view` AS
SELECT A.CPF02 AS UserName, A.CPF07 AS UserIC, B.bmid, B.bm, C.csid, C.cs, D.ksid, D.ks, A.TA_CPF015 AS State, E.zw, E.zwdj
FROM (SELECT CPF02, CPF07, CPF29, CPF30, TA_CPF023, TA_CPF022, TA_CPF015
FROM DS5.CPF_FILE AS CPF_FILE_1
WHERE (CPF29 IS NOT NULL)) AS A INNER JOIN
(SELECT gem01 AS bmid, gem02 AS bm
FROM DS5.GEM_FILE AS GEM_FILE_3
WHERE (LEN(gem01) = '2') OR
(LEN(gem01) = '1')) AS B ON A.CPF29 = B.bmid LEFT OUTER JOIN
(SELECT ta_cpai01 AS zwid, ta_cpai03 AS zw, ta_cpai07 AS zwdj
FROM DS5.TA_CPAI_FILE AS TA_CPAI_FILE_1
WHERE (ta_cpai06 = 'Y')) AS E ON A.TA_CPF022 = E.zwid LEFT OUTER JOIN
(SELECT gem01 AS ksid, gem02 AS ks
FROM DS5.GEM_FILE AS GEM_FILE_1) AS D ON A.CPF30 = D.ksid LEFT OUTER JOIN
(SELECT gem01 AS csid, gem02 AS cs
FROM DS5.GEM_FILE AS GEM_FILE_2) AS C ON A.TA_CPF023 = C.csid
;
[Err] 1349 - View's SELECT contains a subquery in the FROM clause