SQL数据库双表查询问题

[Alfred]

sql="Select * From [Group],[Topic] Where [Topic].GroupID = [Group].ID"
rs.open sql,conn,1,1
Do While Not Rs.Eof
Response.Write Rs("Topic.Title") & "<BR>"
Response.Write Rs("[Group].Title") & "<BR>"
Rs.MoveNext
Loop
Rs.Close
我这样输出两个表的TITLE字段为什么不行，ACCESS就行，SQL要怎样改？

[leohuang]

try
---------------------------
sql="Select a.*,b.* From Topic a left join [Group] b on a.GroupID=b.ID"

[我是丁学]

sql="Select [Group].Title as gTitle,[Topic].Title as tTitle From [Group],[Topic] Where [Topic].GroupID = [Group].ID"
rs.open sql,conn,1,1
Do While Not Rs.Eof
Response.Write Rs("tTitle") & "<BR>"
Response.Write Rs("gTitle") & "<BR>"
Rs.MoveNext
Loop
Rs.Close