https://explainextended.com/2009/07/16/inner-join-vs-cross-apply/ 


Example of use.


get latest price from Tenders.

select t.sgOptionName, b.croptioncalcselling from tblTenderOptions as t

cross apply 
(select top 1 crOptionCalcSelling from tblTenderOptionPrices tp where t.idTenderOption = tp.fkidoption and (tp.dtEffectiveDate < getdate() or tp.dtEffectiveDate is null)
order by tp.idOptionprice desc) as b