新建文本文档 (4)

数据库 waitig 512℃ 百度已收录 0评论

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多表查询 分页 ,排序,更改重复的字段名字


本文由【waitig】发表在等英博客
本文固定链接:新建文本文档 (4)
欢迎关注本站官方公众号,每日都有干货分享!
等英博客官方公众号
点赞 (0)分享 (0)