vw_reservoir

SELECT reservoir.obj_id,

    reservoir.location_name,

    reservoir.situation_geometry,

    connection_object.fk_dataowner,

    connection_object.fk_provider,

    connection_object.fk_wastewater_networkelement,

    connection_object.identifier,

    connection_object.last_modification,

    connection_object.remark,

    connection_object.sewer_infiltration_water_production

   FROM (tww_od.reservoir

     LEFT JOIN tww_od.connection_object ON (((connection_object.obj_id)::text = (reservoir.obj_id)::text)));