From d5c30e1e843c22f9c4869a3d95c47dda24259a84 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期五, 14 十月 2022 14:58:39 +0800 Subject: [PATCH] # --- src/main/resources/mapper/LocDetlMapper.xml | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index f404f3a..80a4ad9 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -372,10 +372,19 @@ ld.loc_no FROM asr_loc_detl ld LEFT JOIN asr_loc_mast lm ON ld.loc_no = lm.loc_no + LEFT JOIN ( + select + loc_no, + count(1) as count + from asr_loc_detl + where 1=1 + group by loc_no + ) dual on dual.loc_no = lm.loc_no WHERE 1 = 1 AND ld.matnr = #{matnr} AND (lm.row1 >= #{start} AND lm.row1 <= #{end}) AND (lm.loc_sts = 'F') + AND dual.count = 1 ORDER BY lm.modi_time ASC </select> -- Gitblit v1.9.1