asp联合查询

<%

set rss=server.createobject("adodb.recordset")

ssql="select * from [dormitory] left join [allot] on allot.r_id=dormitory.r_id and dormitory.build=allot.build where  dormitory.build='"&request("build")&"' order by [dormitory.r_id] asc"

rss.open ssql,conn,1,3

%>