[SQL]SQL語法請教=>使用My SQL

[yld (努力中!!)]

不好意思請教一下
我是My SQL的新手，這問題已經困擾我很久了

select temp.week_ending,temp.total_sold
from
       (select week_ending,sum(units_sold) as total_sold
        from sold
       group by week_ending) as temp
where temp.total_sold =
        (select max(total_sold)
         from
              (select week_ending,sum(units_sold) as total_sold
               from sold
               group by week_ending) as temp2
        )

以上的語法我用於ACCESS與SQL Server中皆可以RUN
但是用在MY SQL中就不能RUN了會出現下列字句
You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version
for the right syntax to use near
'select week_ending,sum(units_sold) as total_sold from

想請問一下是版本問題還是My SQL不支援此種查詢呢
謝謝!!

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 163.22.32.128