Try:

with CTE as

(

select *, ROW_NUMBER() OVER(PARTITION BY AraziID

ORDER BY EghdamatSabt DESC) AS RowNum

from AraziEghdamat

)

select a.*, e.*

from Arazi as a

join CTE as e on e.AraziID = a.AraziID and e.RowNum = 1

Hope this helps.