接着刚才的问题，谢谢
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 != '某一个部门 '