一条语句 因为需要连接好几个数据库 所以很麻烦 我是这么写的
select BeginDate,EndDate,(select RoomName,MeetingRoomMedia,RoomSeat from MeetingRoom where RoomID=MeetingRoomApply.RoomID),ApproveStat,(select Name from Employee where EmpID=MeetingRoomApply.EmpID),(select DeptName from v_emp_post_dept where EmpID=MeetingRoomApply.EmpID),(select Name from Employee where EmpID=MeetingRoomApply.AdminEmpID) from MeetingRoomApply有错误,错误提示是:当没有用EXISTS引入子查询时,在选择列表中只能制定一个表达式
谁可以帮我修改修改!
select BeginDate,EndDate,(select RoomName,MeetingRoomMedia,RoomSeat from MeetingRoom where RoomID=MeetingRoomApply.RoomID),ApproveStat,(select Name from Employee where EmpID=MeetingRoomApply.EmpID),(select DeptName from v_emp_post_dept where EmpID=MeetingRoomApply.EmpID),(select Name from Employee where EmpID=MeetingRoomApply.AdminEmpID) from MeetingRoomApply有错误,错误提示是:当没有用EXISTS引入子查询时,在选择列表中只能制定一个表达式
谁可以帮我修改修改!
b.RoomName,b.MeetingRoomMedia,b.RoomSeat,
a.ApproveStat,
c.Name,
d.DeptName,
e.Name
from MeetingRoomApply AS a
INNER JOIN MeetingRoom AS b ON a.RoomID=b.RoomID
INNER JOIN Employee AS c ON c.EmpID=a.EmpID
INNER JOIN v_emp_post_dept AS d ON d.EmpID=a.EmpID
INNER JOIN Employee AS e ON e.EmpID=a.AdminEmpID
SELECT MRA.BeginDate ,
MRA.EndDate ,
MR.RoomName ,
MR.MeetingRoomMedia ,
MR.RoomSeat ,
MRA.ApproveStat ,
E.NAME ,
VEPD.Deptname ,
E1.NAME
FROM MeetingRoomApply MRA
INNER JOIN MeetingRoom MR ON MRA.RoomID = MR.RoomID
INNER JOIN Employee E ON MRA.EmpID = E.EmpID
INNER JOIN v_emp_post_dept VEPD ON MRA.empid = VEPD.Empid
INNER JOIN Employee E1 ON E1.empid = MRA.adminempid