Xm="张三" sel="select * from info where n1='"&Xm&"' and n2='"&Xm&"'" rs.open sel,conn do until rs.eof response.write rs("Id")&" "&rs("n1")&" "&rs("n2") rs.movenext loop
第2个回答 2008-11-11
select a.* from temp as a,temp as b where a.n1=b.n2 or a.n2=b.n1 order by id asc