如何仅从3个连接表中返回查询中的最新结果

I have 3 tables named Contracts, Bills, and Companies which I have inner joined on a value named "ContractID" which links all 3 tables. I have that query working well, however I would like only the newest result to be pulled. The ContractID field can return multiple results from the Contract table with different dates so DISTINCT isn't working to narrow it down. I have 3 tables named Contracts, Bills, and Com