vw_channel

SELECT channel.obj_id,

    channel.bedding_encasement,

    channel.connection_type,

    channel.function_amelioration,

    channel.function_hierarchic,

    channel.function_hydraulic,

    channel.jetting_interval,

    channel.pipe_length,

    channel.seepage,

    channel.usage_current,

    channel.usage_planned,

    wastewater_structure._bottom_label,

    wastewater_structure._cover_label,

    wastewater_structure._depth,

    wastewater_structure._input_label,

    wastewater_structure._label,

    wastewater_structure._output_label,

    wastewater_structure.accessibility,

    wastewater_structure.condition_score,

    wastewater_structure.contract_section,

    wastewater_structure.detail_geometry3d_geometry,

    wastewater_structure.elevation_determination,

    wastewater_structure.financing,

    wastewater_structure.fk_dataowner,

    wastewater_structure.fk_main_cover,

    wastewater_structure.fk_main_wastewater_node,

    wastewater_structure.fk_operator,

    wastewater_structure.fk_owner,

    wastewater_structure.fk_provider,

    wastewater_structure.gross_costs,

    wastewater_structure.identifier,

    wastewater_structure.inspection_interval,

    wastewater_structure.last_modification,

    wastewater_structure.location_name,

    wastewater_structure.records,

    wastewater_structure.remark,

    wastewater_structure.renovation_necessity,

    wastewater_structure.replacement_value,

    wastewater_structure.rv_base_year,

    wastewater_structure.rv_construction_type,

    wastewater_structure.status,

    wastewater_structure.status_survey_year,

    wastewater_structure.structure_condition,

    wastewater_structure.subsidies,

    wastewater_structure.urgency_figure,

    wastewater_structure.year_of_construction,

    wastewater_structure.year_of_replacement

   FROM (tww_od.channel

     LEFT JOIN tww_od.wastewater_structure ON (((wastewater_structure.obj_id)::text = (channel.obj_id)::text)));