20 lines
447 B
SQL
20 lines
447 B
SQL
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
|
|
|