SELECT VehicleOwner.COMPANY_NAME,
       VehicleOwner.VEHICLE_OWNER_ID,
       Person.COMPANY_NR,
       Person.PERSON_ID,
       Person.FIRST_NAME,
       Person.LAST_NAME,
       VoPersonCategory.NAME,
       VoPersonCategory.VO_PERSON_CATEGORY_ID,
       GuPerson.GUI_USER_ID,
       GuPerson.PERSON_ID AS PERSON_ID1
FROM GU_PERSON GuPerson, PERSON Person, VO_PERSON_CATEGORY VoPersonCategory, VEHICLE_OWNER VehicleOwner
WHERE (guperson.person_id = person.person_id) AND person.person_status_id=0 AND (person.vo_person_category_id = vopersoncategory.vo_person_category_id) AND (vopersoncategory.vehicle_owner_id = vehicleowner.vehicle_owner_id)