asp多条件查询的sql语句

循环：

set rs1

set rs2

sql1 = "select * from t_main where show = true order by id desc"

do while not rs1.eof

rs1("id")

sql2 = "select * from u_user where id = " & rs1("id") & " and show = true order by id desc"

rs2("id")

rs1.movenext

loop

请问ASP多条件搜索的语句怎么写呀 比如在t_main表中的id字段与u_user表中的id对应现在要找在t_main中show=true 并且id在u_user表中show=true的值后面就是用户输入的关键字 和其它字段的值 用倒序排列

只给你写SQL语句

SQL = "Select * From t_main a left join u_user b on b.id=a.id where a.show=true and b.show=true and 关键字='值' and 其它字段=值 order by 排序字段 desc"

没有看明白。。。。。