  select
      a.id          as claim_id,
      a.first_notification_of_loss,
      b.witness_first_name,
      b.witness_family_name
  from
      claim a
      left outer join
      (
          select
              x.claim_id,
              y.first_name   as witness_first_name,
              y.family_name  as witness_family_name
          from
              witness x
              left outer join
              person y
              on x.person_id = y.id
      ) b
      on a.id = b.claim_id;
