1  with Person(ID, FIO) as (
  2  select 100,'Иванов И.И.' from dual union all
  3  select 200,'Иванова А.П.' from dual union all
  4  select 300,'Петров А.П.' from dual union all
  5  select 400,'Петрова А.А.' from dual union all
  6  select 500,'Сидорова А.Ф.' from dual union all
  7  select 600,'Сидорова А.К.' from dual)
  8  ,Pairs(id,IDG, IDM, WEDDING_DATE) as (
  9  select 1,  100,    400,to_date('01-02-98') from dual union all
 10  select 2,  300,    400,to_date('02-10-00') from dual union all
 11  select 3,  500,    600,to_date('02-10-00') from dual )
 12  select g.fio, m.fio, p.max_wedding_date
 13  from
 14  (select t1.idm, t2.idg, t2.max_wedding_date
 15  from
 16  (select idm, max(wedding_date) as max_wedding_date
 17  from pairs
 18  group by idm)t1
 19  left join
 20  (select idg, max(wedding_date) as max_wedding_date
 21  from pairs
 22  group by idg)t2
 23  on t1.max_wedding_date = t2.max_wedding_date) p
 24  , person g
 25  , person m
 26  where p.idg = g.id
 27* and p.idm = m.id
 28  /

FIO           FIO           MAX_WEDD
------------- ------------- --------
Сидорова А.Ф. Сидорова А.К. 02.10.00
Сидорова А.Ф. Петрова А.А.  02.10.00
Петров А.П.   Сидорова А.К. 02.10.00
Петров А.П.   Петрова А.А.  02.10.00