我在用access的时候,出现了一个问题,不知道为什么ORDER BY 不起作用,谁能帮我解答一下。
SELECT announce_master.counter
,(SELECT TOP 1 m_group.gname
FROM m_user,m_group,group_info
WHERE announce_master.uid = m_user.uid
AND m_user.uid = group_info.uid
AND m_group.gid = group_info.gid
AND group_info.uid = m_user.uid
AND m_group.gid <> '00000000000000000000000000000000'
AND m_group.gid <> '11111111111111111111111111111111'
ORDER BY m_group.viewid) as gname
FROM ((announce_master
LEFT OUTER JOIN m_user ON announce_master.uid = m_user.uid)
LEFT OUTER JOIN announce_category ON announce_master.category_id = announce_category.category_id)
WHERE
announce_master.counter IN (28,9,10,11,12,29,30)
ORDER BY 2 ASC