2008-05-21
一个sql语句。
String sql = "SELECT top "+pagesize+" m.memberno AS memberno,m.regname AS regname,m.regtime AS regtime,m.sex AS sex,m.birthday AS birthday,m.regemail AS regemail,m.memberid AS memberid,m.mbtype AS mbtype,(SELECT d.dname FROM b2h_district d WHERE d.idno=a.district) AS district, c.cname as county,a.cname AS realname,a.tel AS hometel,a.officetel AS officetel,a.mobil AS mobil,a.addr AS addr,a.zipcode AS zipcode FROM b2h_member m,b2h_address a,b2h_county c WHERE c.idno = a.countyid and m.memberid=a.memberid AND a.flag=1 ";
评论排行榜