sql 查询

最新推荐文章于 2024-10-06 06:56:01 发布

三人行，必有我师！！！

最新推荐文章于 2024-10-06 06:56:01 发布

阅读量134

点赞数

分类专栏： sql 文章标签： sql

本文链接：https://blog.csdn.net/yangdl6/article/details/88351647

版权

sql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

select distinct t.user_id from
(
	SELECT ipl.user_id
	  FROM phjf_user_info pui 
	       JOIN phjf_ins_policy_life ipl ON pui.user_id = ipl.user_id 
	 WHERE pui.recommend_id = '7' and ipl.status = '5'
	UNION ALL
	SELECT pubr.user_id
	  FROM phjf_user_info pui 
	       JOIN phjf_user_bank_deposit_receipt pubr ON pui.user_id = pubr.user_id 
	 WHERE pui.recommend_id = '7'
) t


select distinct t.user_id from
(
	SELECT ipl.user_id
	  FROM phjf_user_info pui 
	       JOIN phjf_ins_policy_life ipl ON pui.user_id = ipl.user_id 
	 WHERE pui.recommend_id = '7' and ipl.status = '5'
	UNION ALL
	SELECT pubr.user_id
	  FROM phjf_user_info pui 
	       JOIN phjf_user_bank_deposit_receipt pubr ON pui.user_id = pubr.user_id 
	 WHERE pui.recommend_id = '7'
) t group by t.user_id



SELECT distinct pui.user_id
	FROM phjf_user_info pui 
 WHERE pui.recommend_id = '7' 
   and (
					   EXISTS (select user_id from phjf_ins_policy_life ipl where ipl.user_id = pui.user_id and ipl.status = '5')
          OR EXISTS (select user_id from phjf_user_bank_deposit_receipt pubr where pubr.user_id = pui.user_id and pubr.status <> '9')
        )