sql纠错!谢谢!还有如何将查询结果建表 然后再查询?还是可以直接用结果查询.

[umwelt99]

sql="select t1.* from t1,
(select * from userinformation where (user_sex=男) and (firma_sector=重庆)) t2
where t1.user_id=t2.user_id"
这个语句正确不?

还有问一个asp中的问题
sql="select * from userinformation where "
if(request("user_sex")<>"") then
sql=sql&"user_sex='"& request("user_sex")&"' and "

set rs=conn.execute(sql)

哪位能告诉我什么地方错没有?我第一次这样写.没把握.

[blueterry]

1.

select t1.* from t1, t2
where t1.user_id=t2.user_id and
t2.user_sex='男' and
t2.firma_sector='重庆'

2.

sql = "select * from userinformation where "
if(request("user_sex") <> "") then
  sql = sql & " user_sex='" & request("user_sex") & "' "
end if 

set rs = conn.execute (sql)