论坛 › CodeIgniter 问答求助 › 帮忙看下这段SQL怎么写

nymbian 发表于 2011-6-3 15:25:02

SELECT *
FROM staffs
WHERE staffs.department_id = (
SELECT department.department_id
FROM department
WHERE department.department_name =   '行政部' )
UNION
SELECT *
FROM staffs
WHERE staffs.department_id IN (
SELECT low_department_id
FROM department_department
WHERE department_department.high_department_id = (
SELECT department.department_id
FROM department
WHERE department.department_name =   '行政部' )

)

再更新下

nymbian 发表于 2011-6-3 15:26:08

visvoy 发表于 2011-6-3 13:18 static/image/common/back.gif
这种子子子查询看的蛋疼，你能不能用2条查询实现？

已经改成两条了

查看完整版本: 帮忙看下这段SQL怎么写