drop VIEW viw_mik_piezometers;
CREATE VIEW viw_mik_piezometers AS 
select 
SOD_UJ,
SRP_NAME,
OHC_DL_GEOGR,
OHC_SZER_GEOGR,
OHC_RZEDNA_TEREN,
OHC_RZEDNA_TERENU_ACT,
OHC_RZEDNA_KRYZY,
OHC_GLEB_OSTAT,
SOD_DESC,
SOD_PLC
from seg_dev_resources
left join seg_reservoirs_piezometers on SRP_ID=DRS_DEV_ID
left join seg_object_def on SOD_NAME=SRP_NAME
left join seg_object_hole_cards on OHC_NAME=SRP_NAME
where DRS_DEV_TYPE=601 and DRS_STATUS_DIC_ID=7