  CREATE OR REPLACE  VIEW ADM_VW  AS 
  SELECT
    adm.*,
    s.latitude,
    s.longitude,
    s.objectid AS site_objectid,
    type.name  AS type_name,
    manuf.name AS manufacturer_name,
    nep.name AS net_status_name,
    type.model as type_model
    
FROM
    adm
    LEFT JOIN site         s ON s.siteid = adm.siteid
    LEFT JOIN admType      type ON adm.admTYPEID = type.admTYPEID
    LEFT JOIN manufacturer manuf ON type.manufacturerid = manuf.manufacturerid
    LEFT JOIN NepStatus    nep ON nep.id = adm.net_status;