我有一个项目表(project)和一个用户表(user)
projectproject_id first_person second_person third_person
33 12 78 65user
user_id user_name
12 组长
78 处长
65 主任
我想查询project表里project_id=33的first_person,second_person,third_person的名字(是user_name,不是user_id),请问用一个sql语句怎样写出来。谢谢了。
projectproject_id first_person second_person third_person
33 12 78 65user
user_id user_name
12 组长
78 处长
65 主任
我想查询project表里project_id=33的first_person,second_person,third_person的名字(是user_name,不是user_id),请问用一个sql语句怎样写出来。谢谢了。
解决方案 »
- powerdesigner12 逆向工程 sqlserver2005
- 如何判断一个表中两个smalldatetime型的字段相等啊
- 数据表有一个时间字段如2005-11-30,请问怎样分别查询当天的、昨天的、一周以来的记录,谢谢
- 数据库损坏 用no_truncate备份日志 还原无效啊??求助。。
- MSSQL2005 数据库表内删除的数据怎么恢复?急
- ms sql 性能优化顾问
- 我是XP系统,为什么装上个人版SQL SERVER,企业管理器里没有项目,根本不能创建数据库
- 请问SQL SERVER 2005可不可以直接处理XML文件?
- 取出表中n条相同数据内容
- 紧急求救!一个MS sql数据库表无效的问题?非常急,在线等待!
- 有关从远程SQL SERVER向本地ACCESS导出数据的问题
- 关于一个分组求和的问题
(select user_name from [user] where user_id=p.second_person) as second_person,
(select user_name from [user] where user_id=p.third_person) as third_person
from project p
where project_id=33
first_person = (select user_name from user b where b.user_id = a.first_person),
second_person = (select user_name from user b where b.user_id = a.second_person),
third_person = (select user_name from user b where b.user_id = a.third_person)
from project a
where a.project_id=33
b.user_name,
c.user_name,
d.user_name
from project a,user b,user c,user d
where a.first_person = b.user_id
and a.second_person = c.user_id
and a.third_person = d.user_id
b.user_name,
c.user_name,
d.user_name
from project a,user b,user c,user d
where a.first_person = b.user_id
and a.second_person = c.user_id
and a.third_person = d.user_id
select a.project_id ,
first_person = (select [user_name] from [user] b where b.[user_id] = a.first_person),
second_person = (select [user_name] from [user] b where b.[user_id] = a.second_person),
third_person = (select [user_name] from [user] b where b.[user_id] = a.third_person)
from project a
where a.project_id=33