怎么从数据库中根据接收参数来筛选数据？

[netyi2003]

我这里有两个数据表。
一个是tem1,有两个字段，是id和user.
另一个是tem2,有两个字段，是user和lesson.
其中两个数据表的user字段是进行关联的，现在页面传来一个id参数，怎么提取tem2中所有符合user的字段呀？

[bluemoon0001]

set rs=conn.execute("select t2.user as user,t2.lesson as lesson from tem2 as t2 join tem1 as t1 where t1.id="&id)

[bluemoon0001]

不好意思，上面少写了点东西，改为如下：

set rs=conn.execute("select t2.user as user,t2.lesson as lesson from tem2 as t2 join tem1 as t1 on t2.user=t1.user where t1.id="&id)

[netyi2003]

谢谢哈。结帐