SELECT R_LPName,R_HouseType,COUNT(R_HState)R_HState,SUM(case when R_HState = '已售' OR R_HState = '预定' then HX_BuildArea end) SaleArea, SUM(case when R_HState != '已售' AND R_HState != '预定' HX_BuildArea end) UnSaleFROM Room INNER JOIN HXInformation ON HXInformation.HX_Item = Room.R_LPName AND HXInformation.HX_Name = Room.R_HouseType GROUP BY R_LPName,R_HouseType
SELECT R_LPName,R_HouseType,COUNT(R_HState)R_HState,SUM(HX_BuildArea)SaleArea ,COUNT(R_HState)HState,SUM(HX_BuildArea)UnSaleFROM Room INNER JOIN HXInformation ON HXInformation.HX_Item = Room.R_LPName AND HXInformation.HX_Name = Room.R_HouseTypeWHERE R_HState != '已售' AND R_HState != '预定'GROUP BY R_LPName,R_HouseType
SELECT A.*,B.HState,B.UnSale (SELECT R_LPName,R_HouseType,COUNT(R_HState)R_HState,SUM(HX_BuildArea)SaleAreaFROM Room INNER JOIN HXInformation ON HXInformation.HX_Item = Room.R_LPName AND HXInformation.HX_Name = Room.R_HouseTypeWHERE R_HState = '已售' OR R_HState = '预定'GROUP BY R_LPName,R_HouseType ) A INNER JOIN(SELECT R_LPName,R_HouseType,COUNT(R_HState)HState,SUM(HX_BuildArea)UnSaleFROM Room INNER JOIN HXInformation ON HXInformation.HX_Item = Room.R_LPName AND HXInformation.HX_Name = Room.R_HouseTypeWHERE R_HState != '已售' AND R_HState != '预定'GROUP BY R_LPName,R_HouseType) B ON A.LPName=B.LPName AND A.HouseType=B.HouseType
GROUP BY R_LPName,R_HouseType
,COUNT(R_HState)HState,SUM(HX_BuildArea)UnSaleFROM Room INNER JOIN HXInformation ON HXInformation.HX_Item = Room.R_LPName AND HXInformation.HX_Name = Room.R_HouseTypeWHERE R_HState != '已售' AND R_HState != '预定'GROUP BY R_LPName,R_HouseType
(SELECT R_LPName,R_HouseType,COUNT(R_HState)R_HState,SUM(HX_BuildArea)SaleAreaFROM Room INNER JOIN HXInformation ON HXInformation.HX_Item = Room.R_LPName AND HXInformation.HX_Name = Room.R_HouseTypeWHERE R_HState = '已售' OR R_HState = '预定'GROUP BY R_LPName,R_HouseType ) A INNER JOIN(SELECT R_LPName,R_HouseType,COUNT(R_HState)HState,SUM(HX_BuildArea)UnSaleFROM Room INNER JOIN HXInformation ON HXInformation.HX_Item = Room.R_LPName AND HXInformation.HX_Name = Room.R_HouseTypeWHERE R_HState != '已售' AND R_HState != '预定'GROUP BY R_LPName,R_HouseType) B
ON A.LPName=B.LPName AND A.HouseType=B.HouseType
服务器: 消息 156,级别 15,状态 1,行 2
在关键字 'SELECT' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 8
第 8 行: ')' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 20
第 20 行: 'B' 附近有语法错误。
小弟学的不是很好,不太看的懂,能不能帮忙改改