access 双表连接代码

string _sql = "select * from " + db.tName + " INNER JOIN xiangzi ON huanbao.id = xiangzi.tid where tidanhao = '" + System.Web.HttpUtility.HtmlEncode(skey) + "' or xianghao = '" + System.Web.HttpUtility.HtmlEncode(skey) + "'";

posted @ 2009-09-29 14:11  彭成刚  阅读(270)  评论(0编辑  收藏  举报