sql 语句 查找

select c.company,s.truename,s.cellphone from al_company c,al_crm_staff s WHERE c.userid = s.userid AND c.groupid>5 AND c.castingtype=1 AND s.cellphone<>""

posted on 2014-10-24 17:40  五行缺肉  阅读(167)  评论(0编辑  收藏  举报