select RDS.SFR_ID_SECTION Rubrique,
case when PT.SFR_DU_ID_COLUM_T is null then RDS.ID_FIELD else PT.SFR_DU_ID_COLUM_T end Composant,
case when PT.SFR_DU_ID_COLUM_T is null then PAR.ID_FIELD else PART.ID_FIELD end Item
from M4SFR_DU_PARAM_DAT PAR, M4SFR_DU_PAR_R_D_S RDS
left join M4SFR_DU_PARAM_TOT PT on RDS.ID_FIELD = PT.SFR_DU_ID_COLUMN
left join M4SFR_DU_PARAM_DAT PART on PART.SFR_DU_ID_COLUMN = PT.SFR_DU_ID_COLUM_T
where
--RDS.SFR_ID_SECTION like 'SFR_S40_G30%'
--RDS.ID_FIELD like '%NET%'
PAR.ID_FIELD like '%NET%'
and PAR.SFR_DU_ID_COLUMN = RDS.ID_FIELD
order by 1