Запрос

SELECT
F.ID id,
F.LOAD_ID LoadId,
F.OKTMO Oktmo,
F.K_CH Kch,
F.MO_NAME MoName,
F.ADDITIONAL_DATA AdditionalData,
F.INDEX_CODE IndexCode,
F.MEASURE_CODE MeasureCode,
M.NAME MeasureName,
F.YEAR YEAR,
F.VALUE VALUE
FROM P_FORECAST.FORM_MO_SE F
LEFT JOIN P_NSI.NSI_MEASURE M ON F.MEASURE_CODE = M.CODE
WHERE OKTMO = 18701000
AND F.INDEX_CODE = 811
AND F.YEAR IN (2017,2018,2019)