OUTER APPLY 使用，关联表查询返回多个字段

最新推荐文章于 2021-02-28 04:24:49 发布

yizhigang1994

最新推荐文章于 2021-02-28 04:24:49 发布

阅读量413

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/yizhigang1994/article/details/105091243

版权

select * from (
select
LiuShuiHao
,(CASE WHEN HuiFangQingKuang in('配合','不配合',null) THEN 'a' WHEN HuiFangQingKuang is null THEN 'b' ELSE '' END) as GeLiZhuangTai
,One_HuiFangFangShi,One_HuiFangQingKuang,One_FaRe,One_FaLi ,One_KeSouXiongMen,One_TiWen,One_TiWen2,One_QingKuangShuoMing
from FYYQJK_RenYuanHuiFang R WITH (NOLOCK)
OUTER APPLY (SELECT TOP 1 One_HuiFangFangShi=HuiFangFangShi,One_HuiFangQingKuang=HuiFangQingKuang,One_FaRe=FaRe,One_FaLi=FaLi,One_KeSouXiongMen=KeSouXiongMen,One_TiWen=TiWen,One_TiWen2=TiWen2,One_QingKuangShuoMing=QingKuangShuoMing FROM FYYQJK_HuiFangMingXi M WITH (NOLOCK) where HuiFangTianShu=1 AND HuiFangLiuShuiHao=R.LiuShuiHao) AS A1
)a