接着刚才的问题，谢谢
http://community.csdn.net/Expert/topic/5476/5476351.xml?temp=.5458643
我的问题是   在这几个表里   如何   取出不在某一个部门的   所有人员

------解决方案--------------------
try

Select
A.Person_xingming As 姓名,
A.Person_xingbie As 性別, --在這裡加入你要查詢出來的字段
C.BM_name As 部门,
D.zhiwu_name As 职务
From
BM_yuangong A
Inner Join
BM_Person B
On A.Person_id = B.Person_id
Inner Join
BM C
On B.BM_id = C.BM_id
Left Join
BM_zhiwu D
On B.zhiwu_id = D.zhiwu_id And C.BM_id = D.zhiwu_bm_id
Where B.BM_name != '某一个部门 '