with Person(personid,
personname) as
 (select 1, 'p1' from dual),
Car(carid,
carname) as
 (select 1, 'c1'
    from dual
  union
  select 2, 'c2' from dual),
Conn(personid,
carid) as
 (select 1, 1
    from dual
  union
  select 1, 2 from dual)
select p.personid, p.personname, c.carid, c.carname
  from person p, conn con, car c
 where p.personid = con.personid(+) and c.carid = con.carid

  PERSONID PE      CARID CA
---------- -- ---------- --
         1 p1          1 c1
         1 p1          2 c2