1
600SELECT *
FROM (SELECT *
FROM dinginvestpack
WHERE packStatus = 2) d
LEFT JOIN dingpackredeemlist sh ON d.dingInvestPackId = sh.dingInvestPackId
LEFT JOIN dinguserpacksum ze ON ze.packRedeemId = sh.dingPackRedeemId
GROUP BY d.dingInvestPackId,ze.packStatus,ze.requestNo
查询结果出来为什么ze.packStatus有为Null的,但是我原始表的这个字段却是没有为null的.都是0或3,难到它会自动把0转为Null吗,这个字段的数据类型是char.
Copyright 2014-2026 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
收藏
光阴似箭催人老，日月如移越少年。