MYSQL嵌套子查询

最新推荐文章于 2022-10-26 09:20:33 发布

原创最新推荐文章于 2022-10-26 09:20:33 发布 · 189 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

7 篇文章

订阅专栏

	

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;