select
    a.id                          as claim_id,
    a.first_notification_of_loss,
    b.id                          as witness_id
from
    claim a
    left outer join
    witness b
    on a.id = b.claim_id
order by
    claim_id;