select * from acquisition as a left join company as c on a.acquiring_company_id=c.id left join company as cc on a.acquired_company_id=cc.id