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