你这三张表有何关系？通过哪个字段产生联系？

select 

a.FILIALE,

a.BUILD_TEAM_CODE,

a.BUILD_TEAM_TYPE,

a.BUILD_CAPTAIN_CODE,

a.BUILD_CAPTAIN_NAME ,

b.BUILD_TEAM_CODE,b.staff_code,

b.project_code,b.cost_type,b.sum

,

c.build_team_code,c.project_code,c.project_money

from FR_BUILDTEAM_STAFF a 

inner join FR_BUILD_PAYMENT b on a.BUILD_TEAM_CODE,=b.BUILD_TEAM_CODE

inner join FR_PROJECT_BASICS c on a.BUILD_TEAM_CODE,=c.BUILD_TEAM_CODE

where A.WHETHER_UNIT='GC'

and 1eft( contract_input_date,7)='${year}' ${if(len(MS) == 0,"" , "and a.filiale = '”+MS +“")

$fif(len(XM) == 0,"" , "and a.build_team_code = '"+XM+ “")}${if(len(sG)== 0,"" , "and a.build_team_type = '" +SG + "'")}

with a as(第一个select),

b as (第二个select),

c as(第三个select)

select * 

from a

left join b on a.关联字段=b.关联字段

left join c on a.关联字段=c.关联字段