SELECT t1.*,t2.refund_id,t3.reason FROM hq_order AS t1 LEFT JOIN hq_refund AS t2 ON t1.order_id=t2.order_id LEFT JOIN hq_refund_log AS t3 ON t2.refund_id=t3.refund_id WHERE t1.order_status=4 LIMIT 0,10
mysql语句介绍:
连接hq_order、hq_refund、hq_refund_log三张表
查询hq_refund的redund_id,hq_refund_log的reason,hq_order的全部字段
hq_order的order_id等于hq_refund的order_id
hq_refund的refund_id等于hq_refund_log的refund_id
条件是hq_order中的order_status等于4,分页从0开始10条数据