2019年10月31日
xms西软预定列表-房类市场
摘要： select b.descript,sum(a.quan) as quan,case WHEN c.descript is null THEN '团队预留' ELSE c.descript end as mkt_des ,count(distinct roomno) as room from rsvsrc a LEFT JOIN typim b on (a.hotelid=b.hotelid an 阅读全文
posted @ 2019-10-31 11:54 landv 阅读(334) 评论(0) 推荐(0) 编辑