select * from #rkd
left join #ckd on KCRKD1_YWBS=KCCKD1_YWBS and KCRKD1_LYBH=KCCKD1_LYBH and KCRKD2_WLBH=KCCKD2_WLBH and KCRKD2_SSSL=KCCKD2_SL and round(KCRKD2_DJ,4)<>round(KCCKD2_DJ,4)
为什么 #ckd 记录不显示呢?
...全文
1535打赏收藏
LETT JOIN 应用
有如下两个表 分别执行: select * from #rkd left join #ckd on KCRKD1_YWBS=KCCKD1_YWBS and KCRKD1_LYBH=KCCKD1_LYBH and KCRKD2_WLBH=KCCKD2_WLBH and KCRKD2_SSSL=KCCKD2_SL and round(KCRKD2_DJ,4)round(KCCKD2_DJ,4) 为什么 #ckd 记录不显示呢?