帮忙些个sql语句

[飞起来一脚]

用一个sql查询实现以下功能：

select id,title,name from forum where father=0
建立一个记录集
获得rs("id")

select father,name as "姓名" from forum where father=rs("id")
然后列出id,title,name,father,姓名

[sx1123]

select father,name as "姓名" from forum where father=(select id from forum where father=0)

[sx1123]

应该是select father,name as "姓名" from forum where father in (select id from forum where father=0)
不好意思

[笑对最好]

up