我有 2 个表,我想进行一个查询并根据它们的外键对它们进行分组。这是一个例子:
部门
DEPART_ID(PK) - DEPART_NAME
1 - Accounting
2 - IT
雇员
EMP_ID(PK) - NAME - SURNAME - DEPART_ID(FK)
1 - John - John - 1
2 - George - George - 2
Managers
MANAG_ID(PK) - NAME - SURNAME - DEPART_ID(FK)
1 - Nick - Nick - 1
2 - Michael - Michael - 2
我想获得按部门名称分组的输出。
Accounting | IT
----------------|-------------------
John John | George George
Nick Nick | Michael Michael
我已经尝试过,但无法使其发挥作用。最好的方法是什么?
你可以通过使用这个来得到你想要的:
select * from
(select name || ' ' || Surname Accounting from employees where depart_id = 1),
(select name || ' ' || Surname IT from employees where depart_id =2)
union
select * from
(select name || ' ' || Surname Accounting from managers where depart_id = 1),
(select name || ' ' || Surname IT from managers where depart_id =2)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)