select DISTINCT( b.userid as 用户ID,b.user_name as 用户名称,b.user_nickname as 用户昵称,c.dept_name as 部门名称 )from user_dept a,user b,dept c where a.deptid=c.deptid and a.userid=b.userid and (b.user_name like '%+keyword+%' or b.user_nickname like '%+keyword+%' ) order by b.userid
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货