SELECT

A.HOTELID,

A.ISDIRECT AS 是否直营,

B.DIVISION AS `事业部`,

SUM(C.`DAY`) AS `本月收入`

FROM

ods_xms_hotelid AS A,

ods_fr_hotelextend AS B,

dw_fd_ynjourrep AS C

WHERE

A.HOTELID = B.HOTELID 

AND B.HOTELID = C.HOTELID

AND A.SECTIONID = 'HOTEL' 

AND C.CLS = 70000000 

and a.mytime>='${DATEINMONTH(today(),1)}'/*改成你自己表的日期字段*/

and a.mytime<='${today()}'/*改成你自己表的日期字段*/

GROUP BY  A.HOTELID,A.ISDIRECT,B.DIVISION

  ORDER BY A.HOTELID

SELECT

A.HOTELID,

A.ISDIRECT AS 是否直营,

B.DIVISION AS `事业部`,

SUM(C.`DAY`) AS `本月收入`

FROM

ods_xms_hotelid AS A,

ods_fr_hotelextend AS B,

dw_fd_ynjourrep AS C

WHERE

A.HOTELID = B.HOTELID 

AND B.HOTELID = C.HOTELID

AND A.SECTIONID = 'HOTEL' 

AND C.CLS = 70000000 

and cast (rq  AS DATE) BETWEEN  CAST(DATEADD(dd,-day(getdate())+1,getdate()) AS date) AND CONVERT(VARCHAR(30),GETDATE(),23)      ----(把rq改成你的日期字段)

GROUP BY  A.HOTELID,A.ISDIRECT,B.DIVISION

  ORDER BY A.HOTELID