MYSQL嵌套子查询

	

SELECT
	t3.sid
FROM(
		SELECT DISTINCT
			t1.id,
			t1.sex,
			t1. NAME,
			t1.sid,
			t1.type
		FROM(SELECT t.id,t.`name`,t.sex,t.sid,t.type FROM t_as t	WHERE t.type = '监管'AND t.sid IS NOT NULL) t1,
			(SELECT t.id,t.`name`,t.sid,t.type FROM	t_as t WHERE	t.type = '内部') t2 WHERE	t1.id = t2.sid OR t1.sid = t2.id
	) t3;