vw_building

SELECT building.obj_id,

    building.house_number,

    building.location_name,

    building.perimeter_geometry,

    building.reference_point_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.building

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