我要被急死啦!!!!!!!!!!!!
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 行: '' 附近有语法错误。
杂症啊??????????????????????