select 
t1.*,t2.name,t3.sex
from 
活动 t1
inner join 人 t2
inner join 人 t3 on 
where
t2.emp_id in('','',
	/*人*/
	select emp_id
	from employee t1
	inner join org t2
	where t1.sex ='男'
)


select * 
from 人员
where
(sex='男' and age=30) 1
or/and
(sex='女' and age=40) 2
emp_id not( 排除
	select emp_id 
	from 人员
	where
	(sex='女' and age=39) 
)