select dest.version_year as 年度,
dest.version_period as 期次,
from dmt_economic_statistics_info as dest
left join dmt_dim_project ddp on dest.project_id=ddp.project_id
where 1=1
<version_year> and dest.version_year in (?{version_year}) </version_year>
<version_period> and dest.version_period in (?{version_period}) </version_period>
<belong_unit> and dest.belong_unit in (?{belong_unit}) </belong_unit>
<project_type> and dest.project_type in (?{project_type}) </project_type>
<project_is_contract> and dest.project_is_contract in (?{project_is_contract}) </project_is_contract>
<project_region> and ddp.project_region in (?{project_region}) </project_region>
<project_holding_type> and ddp.project_holding_type in (?{project_holding_type}) </project_holding_type>
<project_prvc> and dest.project_prvc in (?{project_prvc}) </project_prvc>
<proejct_jurisdiction> and ddp.proejct_jurisdiction in (?{proejct_jurisdiction}) </proejct_jurisdiction>
<project_is_group> and dest.project_is_group in (?{project_is_group}) </project_is_group>
group by dest.version_year,dest.version_period,dest.project_status |
显示全部楼层
发表于 2022-6-21 11:21:02
