简单sql查询

连表查询数据

SELECT a.id, b.order_id, b.repay_time
FROM  `laba_merchant_order` AS a
JOIN  `laba_merchant_order_detail` AS b ON a.id = b.order_id
WHERE b.repay_time >=1531670400
AND b.repay_time <=1531756799
AND a.is_delete =0
AND b.is_delete =0
LIMIT 0 , 30