Question

asp中sql语句两个表格一起用怎么说?

我想实现sheet2表中rid等于request("id")是不是这么写?
<% sql="select * from sheet1,sheet2 where rid="&request("id") %>

------------------------------------------------------

如果我想实现sheet1中的name=request("name"),sheet2中的rid=request("id") 是不是象下面这么写?

<% sql="select * from sheet1 where name='"&request("name")&"',sheet2 where rid="&request("id") %>

Answer 1

SQL 语句
Select * FROM sheet1 INNER JOIN sheet2 ON sheet1.rid=requeset("id") and sheet2.name like '"&request("name")&"'
说明一下,字符窜用like
'"&request("name")&"'好象可以直接这样用'request("name")'

Answer 2

select * from sheet1,sheet2 where sheet1.rid=request("id") and sheet2.name=request("name")

Answer 3

select * form sheet1,sheet2 where sheet2.rid=sheet1.id