Q:

Ordering on two criteria, SQL

Above is my output from my query.  I would like to alphabetize the dischargetype while also grouping metro, appalachia and rural TRUES together i.e. all the 1s for metro, rural and appalachia are in the right order, but how do i alphabetize the first column.  Below is my query
SELECT     tblDischarge.dischargeType, COUNT(tblDischarge.dischargeType) AS counts, tblVisits.diabetes, tblVisits.hemiplegia, tblKentuckyCounties.Metro, 
                      tblKentuckyCounties.Appalachia, tblKentuckyCounties.Rural
FROM         tblKentuckyCounties INNER JOIN
                      tblVisits ON tblKentuckyCounties.countyID = tblVisits.countyID INNER JOIN
                      tblDischarge ON tblVisits.DischargeStatus = tblDischarge.dis_statID
WHERE     (tblVisits.diabetes = 1) AND (tblVisits.hemiplegia = 1)
GROUP BY tblDischarge.dischargeType, tblVisits.diabetes, tblVisits.hemiplegia, tblKentuckyCounties.Metro, tblKentuckyCounties.Appalachia, tblKentuckyCounties.Rural
HAVING      (tblDischarge.dischargeType LIKE '%routine%') OR
                      (tblDischarge.dischargeType LIKE '%short-term%') OR
                      (tblDischarge.dischargeType LIKE '%icf%') OR
                      (tblDischarge.dischargeType = 'home health') OR
                      (tblDischarge.dischargeType LIKE '%swing%') OR
                      (tblDischarge.dischargeType LIKE 'rehab%') OR
                      (tblDischarge.dischargeType LIKE '%long-term%')
ORDER BY tblKentuckyCounties.Appalachia, tblKentuckyCounties.Rural, tblKentuckyCounties.Metro

A:

Change last line to:
ORDER BY tblKentuckyCounties.Appalachia, tblKentuckyCounties.Rural, tblKentuckyCounties.Metro, tblDischarge.dischargeType

