11

来自「很不错的客房管理软件.第9次改版正式开通.每日更新.」· 代码 · 共 10 行

SELECT c.Rtype, d.RCount1, d.Operation
FROM TypeTab c,
    (SELECT COUNT(a.aroom) as RCount1, a.Operation, b.Rtype
     FROM OperatTab a, RoomTab b
     WHERE (a.aRoom=b.ID)
     GROUP BY b.Rtype, a.Operation) d
WHERE c.id=d.Rtype