2015-12-01 08:56:14正常:SQL: SELECT t_rm_saleflow.branch_no , -- '门店', count(distinct t_rm_saleflow.flow_no) flow_no, sum(t_rm_saleflow.sale_qnty ) sale_qnty,-- '销售数量', sum( t_rm_saleflow.sale_money ) sale_money, CONVERT(varchar(11) , t_rm_payflow.oper_date , 20 ) pay_date FROM t_rm_saleflow, t_rm_payflow WHERE ( t_rm_saleflow.flow_no = t_rm_payflow.flow_no ) and ( t_rm_payflow.branch_no = t_rm_saleflow.branch_no ) and ( t_rm_payflow.oper_id = t_rm_saleflow.oper_id ) and ( t_rm_payflow.flow_id=1 and t_rm_payflow.pay_way '' ---参数 and t_rm_payflow.oper_date 'MOY') and t_rm_saleflow.sell_way='A' --as sale_price sell_way B:退货 A:销售 and t_rm_payflow.oper_date>'' ---参数 and t_rm_payflow.oper_date 'MOY') and t_rm_saleflow.sell_way='B' --as sale_price sell_way B:退货 A:销售 and t_rm_payflow.oper_date>'2015-11-29' ---参数 and t_rm_payflow.oper_date<'2015-11-30' ---参数group by t_rm_saleflow.branch_no, t_rm_payflow.oper_date
这是执行log,为什么一段SQL要执行多次,第一次参数没有值,第二次参数才有值。