如何SQL SERVER 2005 多个SELECT语句(行数都相同)组合成一个视图

[复制链接]
查看11 | 回复1 | 2012-1-8 10:16:36 | 显示全部楼层 |阅读模式
(SELECT StaffID AS '员工编号',StaffName AS '员工姓名',Sex AS '性别',Identitycard AS '身份证',NowDeptID AS '在职部门编号',Dept.DeptName AS '在职部门名称',Classinfo.ClassName AS '住宿情况',Classinfo.ClassName AS '学历',Phone AS '电话',Addres AS '地址',Email AS '电子邮件',Remark AS '备注' FROM Staffinner join Dept ON Staff.NowDeptID=Dept.DeptIDinner join ClassInfo ON S...
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行