mmbarname
یک شنبه 04 دی 1390, 20:29 عصر
سلام . کسی میدونه مشکله این کد چیه فکر کنم 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))
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))