求 sql 语句 急

[lzt7]

用的是Access数据库,假使两个表
设计部:design
ID UName
1 王老虎
2 李俊
3 章军报
4 为小宝
5 王老虎
6 章军报
7 为小宝
8 王老虎



IT部:it
ID UName
1 王老虎
2 李俊
3 章军报
4 为小宝
5 王老虎
6 章军报
7 为小宝
8 王老虎

我想用group by UName把同时两个表的人员列出来,该怎么写sql语句啊?

[王集鹄]

--估计是这样，没有调试过

select UName
from design
where exists(select * from it UName = design.UName)
group by UName

[王集鹄]

--另外参考：
select UName
from design
group by UName
having count(*) >= 2

你想要查询出的结果也不列出来
“同时两个表的人员列出来”是嘛意思

[lzt7]

是用这个吗?

select * from
(
select f from a
union all
select f from b
)
group by

[lzt7]

我是想用sql语句显示一个临时表
只有一个字段 UName,这个字段里面的姓名是从上面两个表中取得,而且去除重复
该怎么写sql

[王集鹄]

//Access调试通过

select UName
from
(
select UName
from design
union all
select UName
from it
)
group by UName

[sunyongwang]

select distinct a.UName From
(Select UName from design
union
Select UName from it
) a

[allen_cn]

说的不清楚
如果要取两个表，直接union就可以了

[sunmbije]

是不是这个，你试试。

SELECT DISTINCT dbo.design.UName
FROM dbo.design FULL OUTER JOIN
dbo.design it ON dbo.design.产品编号 = it.UName
GROUP BY dbo.design.UName

[sunmbije]

上边那个有误，你试这个

SELECT DISTINCT dbo.design.UName
FROM dbo.design FULL OUTER JOIN
dbo.design it ON dbo.design.UName = it.UName
GROUP BY dbo.design.UName