Home Forums SQL Server 2008 SQL Server 2008 - General Error With Query RE: Error With Query
imex
Ten Centuries
Points: 1234
More actions
October 6, 2012 at 4:15 pm
#1546450
Try:
select a.*, max(e.EghdamatSabt) as EghdamatSabt
from Arazi as a
join AraziEghdamat as e on e.AraziID = a.AraziID
group by a.*
Hope this helps.