asp sql 跨表查询

select * from 表二 t2 where t2.uid in
(select id from 表一 t1
where t1.id = 'db')
and rownum < 3 order by t2.id2;

就是2次查询么..怎么说跨表呢
sql="select * from 表一 where clo="ab"
查找表一里符合ab的记录
rs.open sql,conn,1,1

while not rs.eof
循环读取相应记录
sql="select top 2 * from 表二 where uid="&rs("id")&""
rs1.open sql,conn,1,1
根据循环出来的id来查找表二符合id的记录
while not rs1.eof
response.write rs1("name2")
rs1.movenext
wend
rs.movenext
wend

select top 2 * from T2 where uid in
(
select top 2 id from T1 where clo = 'ab' --从 表一 查到 clo=ab 的两条记录
)然后查询 表二 取到uid=id的 前两条记录

select id2,name2,uid from(
select t2.id2,t2.name2,t2.uid,row_number()over(partition by uid order by id2) row_ from table2 t2, table1 t1 whe