use bluehill
go
create view viwwebEmpCommonInfo
as
select ?
e.EmployeeID as employee_id,
? e.[Name] as employee_name,
? e.Email as employee_email,
? e.Telephone as employee_telephone,
? e.LoginName as employee_loginname,
? e.[Password] as employee_password
? e.OnboardDate as employee_onboarddate,
? t.DeptName as employee_deptname,
? t.ManagerID as employee_managerid,
? e.SelfIntro as employee_selfintro,
? e.vacationRemain as employee_vacationremain
from tblemployee as e inner join tbldepartment as t on e.deptid=t.deptid
错误信息：：：
服务器: 消息 170，级别 15，状态 1，过程 viwwebEmpCommonInfo，行 3
第 3 行: '?' 附近有语法错误。
杂症啊？？？？？？？？？？？？？？？？？？？？？？
------解决方案--------------------
employee_password --少个逗号