From 0240bd3dce4e815e04c4e59aaef9b6bd7d0b0040 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期日, 28 九月 2025 11:40:02 +0800
Subject: [PATCH] 查询改动
---
framework/src/main/resources/mapper/lmk/StoreCouponClaimRecordMapper.xml | 5 ++---
1 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/framework/src/main/resources/mapper/lmk/StoreCouponClaimRecordMapper.xml b/framework/src/main/resources/mapper/lmk/StoreCouponClaimRecordMapper.xml
index 3d21ff9..895bfab 100644
--- a/framework/src/main/resources/mapper/lmk/StoreCouponClaimRecordMapper.xml
+++ b/framework/src/main/resources/mapper/lmk/StoreCouponClaimRecordMapper.xml
@@ -79,8 +79,7 @@
FROM
lmk_store_coupon_claim_record lsccr
INNER JOIN
- li_member_coupon lmc ON lmc.coupon_id = lsccr.coupon_id
- AND lmc.member_id = lsccr.user_id
+ li_member_coupon lmc ON lmc.member_coupon_id = lsccr.member_coupon_id
WHERE
lmc.delete_flag = 0
AND lsccr.delete_flag = 0
@@ -136,7 +135,7 @@
FROM
lmk_store_coupon_claim_record lsccr
INNER JOIN
- li_member_coupon lmc ON lmc.coupon_id = lsccr.coupon_id
+ li_member_coupon lmc ON lmc.member_coupon_id = lsccr.member_coupon_id
WHERE
lmc.delete_flag = 0
AND lsccr.delete_flag = 0
--
Gitblit v1.8.0