vw_leapingweir

SELECT leapingweir.obj_id,

    leapingweir.length,

    leapingweir.opening_shape,

    leapingweir.width,

    overflow.actuation,

    overflow.adjustability,

    overflow.brand,

    overflow.control,

    overflow.discharge_point,

    overflow.fk_control_center,

    overflow.fk_dataowner,

    overflow.fk_overflow_char,

    overflow.fk_overflow_to,

    overflow.fk_provider,

    overflow.fk_wastewater_node,

    overflow.function,

    overflow.gross_costs,

    overflow.identifier,

    overflow.last_modification,

    overflow.qon_dim,

    overflow.remark,

    overflow.signal_transmission,

    overflow.subsidies

   FROM (tww_od.leapingweir

     LEFT JOIN tww_od.overflow ON (((overflow.obj_id)::text = (leapingweir.obj_id)::text)));