ASP查询，帮忙
sql= "select * from larchives where chatroom=yes "
sql= "select user_id,name,sex,education,britherday,click,company,home,date,photo from larchives "
if search_txt <> " " then
sql1=sql & " where name like '% " & search_txt & "% ' "
sql1=sql & " or sex like '% " & search_txt & "% ' "
sql1=sql & " or education like '% " & search_txt & "% ' "
sql1=sql & " or britherday like '% " & search_txt & "% ' "
sql1=sql & " or click like '% " & search_txt & "% ' "
sql1=sql & " or cstr(company) like ' " & search_txt & " ' "
sql1=sql & " or date like '% " & search_txt & "% ' "
'sql=sql & " or chatroom like '% " & yes & "% ' "
end if
我想把chatroom=yes 和查询结合起来，就是只查询表中chatroom=yes的内容，怎么写呀，高手帮忙，实在没分了，感谢感谢。
[解决办法]
sql= "select * from larchives where chatroom=yes "
sql= "select user_id,name,sex,education,britherday,click,company,home,date,photo from larchives "
