常用sql语句总结

第一、根据id查询订单和订单关联的客户信息

select * from t_order tor join t_customer tcu on tor.customer_id = tcu.customer_id where tor.order_id = #{id}