主题：[求助]关于Foxtable输入中文拼音索引

http://foxtable.com/bbs/dispbbs.asp?BoardID=2&ID=150626&replyID=&skin=1

写了什么代码？有什么具体的错误？

Select  Name As [酒店名称],a.[主机总数],a.[在线数],a.[主机总数] - a.[在线数] As [离线数],b.故障数 From tb_Sys_Hotels Left JOIN (SELECT [HotelID], COUNT(*) AS [主机总数],SUM([Status]) As [在线数]  FROM tb_Hosts GROUP BY [HotelID] ) as a ON a.[HotelID] = {tb_Sys_Hotels}.[ID] left join (Select  ID,Count(HostID) as 故障数 From tb_HostFaultRecords group by ID) as b on {tb_Sys_Hotels}.[ID] = b.ID ORDER BY a.[HotelID]

tb_Sys_Hotels表里的酒店id都没有故障，自己检查数据，或者关联的ID是否正确

tb_HostsFaultRecords通过什么列和酒店关联？

Select  Name As [酒店名称],a.[主机总数],a.[在线数],a.[主机总数] - a.[在线数] As [离线数],b.故障数 From tb_Sys_Hotels Left JOIN (SELECT [HotelID], COUNT(*) AS [主机总数],SUM([Status]) As [在线数]  FROM tb_Hosts GROUP BY [HotelID] ) as a ON a.[HotelID] = {tb_Sys_Hotels}.[ID] left join (Select  d.HotelID,Count(c.HostID) As 故障数 From (Select  Distinct HostID From tb_HostFaultRecords) As c Inner join tb_Hosts As d on c.HostID=d.id group by d.HotelID) as b on {tb_Sys_Hotels}.[ID] = b.HotelID ORDER BY a.[HotelID]