CampaignMax query to list companies and their CEOs

SELECT
company.displayname,
person.displayname,
rel.relatednametitle
from
camnamesonlyv company,
camnamesonlyv person,
camrelationships rel,
camrelationtypes rtypes
where
company.nametype = 'O'
and company.nameid = rel.nameid (+)
and NVL(rel.relatednameid,0) = person.nameid (+)
and NVL(rel.relationtypeid,0) = rtypes.relationtypeid (+)
and rtypes.childdesc = 'CEO'