دستور Sql

[mmbarname]

سلام . کسی میدونه مشکله این کد چیه فکر کنم groupBy می خواد که من بلد نیستم ؟
SELECT TOP (200) Travel.CustomerId, Travel.d_date, Travel.code, Travel.go_time, Travel.money, driver.name, ostan.name AS Expr1, city.name AS Expr2
FROM Travel INNER JOIN
driver ON Travel.driver_id = driver.id INNER JOIN
ostan ON Travel.OstanId = ostan.id INNER JOIN
city ON ostan.id = city.ostanId
where (Travel.code = MAX(Travel.code))

[zarrinnegar]

اینو تست کن ببین جواب میده


SELECT TOP (200) T.CustomerId, T.d_date, T.code, T.go_time, T.money, driver.name, ostan.name AS Expr1, city.name AS Expr2
FROM Travel as T INNER JOIN
driver ON Travel.driver_id = driver.id INNER JOIN
ostan ON Travel.OstanId = ostan.id INNER JOIN
city ON ostan.id = city.ostanId
where (Travel.code = (select MAX(Travel.code) from Travel where CustomerId= t.CustomerId)