还是 join+where问题

浏览:1121 发布日期:2015/07/02 分类:求助交流
xxSELECT introduce,steward.person_id,steward.steward_id,steward.real_name,ranks_name,photo_img,department_name,area_name,expertise,org_name FROM app_ucenter_v1.steward LEFT JOIN app_service_v1.steward_service cmsvc ON steward.PERSON_ID=cmsvc.PERSON_ID WHERE 1=1 and steward.dstatus!=-1 and steward.status=1 AND cmsvc.SERVICE_TYPE=3 GROUP BY steward.STEWARD_ID ORDER BY `SORT` DESC
直接在数据库中运行正常,但在框架下报错:
SQLSTATE[42S22]: Column not found: 1054 Unknown column cmsvc.SERVICE_TYPE in where clause
最佳答案
评论( 相关
后面还有条评论,点击查看>>