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
OUTER APPLY 使用, 关联表查询返回多个字段
最新推荐文章于 2021-02-28 04:24:49 发布