SQL table Alias

I have the following SQL statement where the Company table is joined 3 times. There is a CompanyName column in the Company table How do I tell my c# code which alias to read?

reader["ex.CompanyName"] does not work

Select *
from Shipments sh
inner join Company cn on cn.CompanyId = sh.ConsigneeID
inner join Company ex on ex.CompanyId = sh.ExporterId
inner join Company fw on fw.CompanyID = sh.ForwarderID

You need to sign in to view this answers