56,679
社区成员
发帖
与我相关
我的任务
分享
Select 'ddd' b,ii.item_id, ii.item_code, ii.item_cn_name, ii.item_en_name,
year(mda.period_start_date) y, month(mda.period_end_date) m, mda.metadata_type, mda.metadata_code,
mda.period_type, mda.data_id, md.data_value, mda.data_attr_code, mda.data_scale_code, mda.data_unit_code
FROM csf_maec.maec_data_attr mda LEFT JOIN csf_maec.item_info ii ON mda.item_id=ii.item_id
LEFT JOIN csf_maec.maec_data md ON mda.data_id = md.data_id
WHERE ii.item_code ='001.001.001.002'
AND mda.period_type = 'Y'
and mda.data_attr_code = 'CV'
and (
(mda.metadata_type = 'PRICE' AND mda.metadata_code='CURRENT')
or
(mda.metadata_type = 'AREA' AND mda.metadata_code='PBJ')
or
(mda.metadata_type = 'INDUSTRY' AND mda.metadata_code='INDUSTRY_1ST')
)
GROUP BY mda.data_id
HAVING count(mda.data_id)=3 ;