急！！！！高手帮忙：关于子查询的问题！
下面是查询句子：能否用子查询代替inner jion...on呢？
SELECT a.地区,SUM(b.人数)
FROM table_a As a INNER JOIN
table As b ON
a.身份id = b.身份id
WHERE a.年龄 ='21'
GROUP BY a.地区
问题点数：0、回复次数：1Top
1 楼WangZWang（先来）回复于 2004-12-02 16:45:50 得分 0
SELECT a.地区,SUM(b.人数) as 人数合计
FROM table_a As a,table As b
WHERE a.身份id = b.身份id and a.年龄 ='21'
GROUP BY a.地区Top
