新建文本文档 (4)

Mysql多表查询 分页,排序

select app_order.,d_driver. ,d_device.* ,d_driver.id as d_id from ( app_order left join d_driver on app_order.driver_id =d_driver.driver_number and app_order.driver_id is not null) left join d_device on app_order.device_id = d_device.dev_id and app_order.device_id is not null where phone_number=’15015626908’ order by order_state asc , reserve_time asc limit 0,10

随笔 mysql多表查询 分页 ,排序,更改重复的字段名字