两张的变量如何取值?

[cdwfeng]

以第一个表info中的某个ID取到的值

<%
dim id
id=trim(request("id")
set rs=server.createobject("adodb.recordset")
sql="select * from info where id="&id
rs.open sql,conn,1,1
%>

要从第二个表中取reid=该id的值
<%
set rs2=server.createobject("adodb.recordset")
sql="select * from user where reid="&id
rs2.open sql,conn,1,1
%>
应该怎样写?

[hookee]

sql = "select a.* from user a left join info b ON a.reid=b.id where b.id=" & id