34,590
社区成员
发帖
与我相关
我的任务
分享
select ta.account_id ,ta.corpname,tfv.pk_id pk_id,tfv.state,pd.name area
from t_account ta
left outer join t_freeEvaluationApply tfv on ta.account_id = tfv.fk_account_id
left outer join pub_district pd on ta.fk_province_id =pd.pk_id
--试试
select ta.account_id ,ta.corpname,tfv.pk_id pk_id,tfv.state,pd.name area
from t_freeEvaluationApply tfv
left outer join t_account ta on ta.account_id = tfv.fk_account_id
left outer join pub_district pd on ta.fk_province_id =pd.pk_id