select '采礦權' kqtype2,
to_char(sum(e.""年產油(萬噸)""), '99999999999.9999') yearYou,
to_char(sum(e.""年產氣(萬方)""), '99999999999.9999') yearQi,
to_char(sum(e.""累產油(萬噸)""), '99999999999.9999') leiYou,
to_char(sum(e.""累產氣(億方)""), '99999999999.9999') leiQi,
to_char(sum(e.""累產凝析油（萬噸）""), '99999999999.9999') leiNi,
sum(e.""累放空氣(萬方)"") leiAir
FROM MR_OG_min_ITEM a
join SI_OG_min_WELL b
on a.ID_LICENCEID = b.ID_LICENCEID
and a.YEAR = b.YEAR
join BASE_WELL c
on b.wellid = c.well_id
join MV_A2_PRO_MON e
on e.A2井ID = c.a2_id
where a.YEAR = @year
and e.年月 = '@yearmonth'
uj5u.com熱心網友回復：
麻煩各位大牛幫忙看看轉載請註明出處，本文鏈接：https://www.uj5u.com/net/284523.html
標籤：C#