SELECT t1.*,t2.order_status FROM hq_refund AS t1 LEFT JOIN hq_order AS t2 ON t1.order_id=t1.order_id WHERE t1.order_id='2020080915969502173022139'
mysql语句介绍:
查询hq_refund和hq_order表
hq_refund别名为t1,hq_order别名为t2
查询t1的所有内容,查询t1的order_status字段
hq_refund的order_id=hq_order的order_id
查询条件是t1的order_id=‘2020080915969502173022139’