vw_flushing_nozzle

SELECT flushing_nozzle.obj_id,

    flushing_nozzle.situation_geometry,

    structure_part.fk_dataowner,

    structure_part.fk_provider,

    structure_part.fk_wastewater_structure,

    structure_part.identifier,

    structure_part.last_modification,

    structure_part.remark,

    structure_part.renovation_demand

   FROM (tww_od.flushing_nozzle

     LEFT JOIN tww_od.structure_part ON (((structure_part.obj_id)::text = (flushing_nozzle.obj_id)::text)));