mysql 多表查询(笔计)

 

 

select  r.id as rid,rt.id as rtid,rt.roomname as rtroomname,r.roomPrice as rroomPrice,

r.maxNum as rmaxNum,r.roomDescript as rroomDescript,sh.id as shid,sh.subHotelName as shsubHotelName,

sh.subHotelAddress as shsubHotelAddress ,sh.isLeader as shisLeader

from room as r INNER JOIN roomType as rt on r.roomTypeId=rt.id

inner join subHotel as sh on r.subHotelId=sh.id order by r.roomPrice asc limit 5,5

 

room 表

roomType 表

subHotel  表

 

对应关系是

room.roomTypeid=roomType.id

room.subhotelid=subhotel.id

//排序这后，还可以分页，好像以前不行吧，这是我现在的疑问，先记下吧