SELECT
d.detail_code,
d.money,
d.create_time,
d.update_time,
be.re,
u.user_code,
u.nick_name,
bi.real_money,
bi.cope_money
FROM t_finance_bill_detail d LEFT JOIN t_finance_bear be ON d.bear_code = be.bear_code
LEFT JOIN t_finance_bill bi ON d.bill_code = bi.bill_code
LEFT JOIN t_user u ON d.user_code = u.user_code
WHERE (date_sub(curdate(), INTERVAL 30 DAY) <= date(d.update_time)) AND (date_sub(curdate(), INTERVAL 60 DAY) > date(d.update_time));
单个条件可以查询出结果,可组合到一起就查不出数据了
在线急等!!!
d.detail_code,
d.money,
d.create_time,
d.update_time,
be.re,
u.user_code,
u.nick_name,
bi.real_money,
bi.cope_money
FROM t_finance_bill_detail d LEFT JOIN t_finance_bear be ON d.bear_code = be.bear_code
LEFT JOIN t_finance_bill bi ON d.bill_code = bi.bill_code
LEFT JOIN t_user u ON d.user_code = u.user_code
WHERE (date_sub(curdate(), INTERVAL 30 DAY) <= date(d.update_time)) AND (date_sub(curdate(), INTERVAL 60 DAY) > date(d.update_time));
单个条件可以查询出结果,可组合到一起就查不出数据了
在线急等!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货