SELECT wb.WBS_ID, wb.REF_NUMBER, wb.NAME WBS_NAME, poi.NAME POI_NAME, poi.OC_POI_CATEGORY_ID, poi.SHORT_NAME,
poi.STREET || ' ' || poi.STREET_NR || ' ' || poi.LOCATION || ' ' || poi.POST_CODE || ' ' || poi.COUNTRY AS Address,
initcap(gui.FIRST_NAME) || ' ' || initcap(gui.LAST_NAME) AS Name
FROM gui_users gui, oc_poi poi, wbs wb
WHERE gui.poi_id = poi.poi_id
AND poi.poi_id = wb.poi_id
--and poi.operation_center_id = oc.operation_center_id
AND UPPER(poi.country) LIKE 'BE'
AND gui.poi_id IS NOT NULL;