SQL语句语法错误

[yongxianhai]

select * from
(
(
(SELECT BuildingID, HouseID,[Floor],RoomNum, HouseTypeName, Remark FROM House , HouseType where House.HouseTypeID = HouseType.HouseTypeID)as h
LEFT JOIN
(SELECT HouseID,COUNT(*) HouseHolderNum FROM HouseholderInHouse GROUP BY HouseID)as D
ON h.HouseID = D.HouseID
) as P
LEFT JOIN
(SELECT HouseID,COUNT(*) ResidentNum from ResidentInHouse GROUP BY HouseID ) as R
ON P.HouseID = R.HouseID
) as K

说 as P 和as R处有语法错误，不是很懂，那位兄台指点一下

[fanzhouqi]

问题我没看出来 这个你可以试试看

select * from 
( 

	(SELECT BuildingID, HouseID,[Floor],RoomNum, HouseTypeName, Remark FROM  House , HouseType where House.HouseTypeID = HouseType.HouseTypeID)as h 
	LEFT JOIN (SELECT HouseID,COUNT(*) HouseHolderNum FROM HouseholderInHouse GROUP BY HouseID)as D 
		ON h.HouseID = D.HouseID 
	LEFT JOIN (SELECT HouseID,COUNT(*) ResidentNum from ResidentInHouse GROUP BY HouseID ) as R 
		ON h.HouseID = R.HouseID 
) 

[Stone19840824]

select * from 
( 
 (h LEFT JOIN D ON h.HouseID = D.HouseID ) as P 
 LEFT JOIN R ON P.HouseID = R.HouseID 
) as K 

把楼主的代码简化一下
h前面好像少了查询语句吧

[yongxianhai]

谢谢各位