[SOLVED] ORA-00936 with Oracle script

[stockton]

The following SQL returns ORA-00936 when run.

select 	MemNumber,
	Turnover
from
(
	select mem_number MemNumber,
	sum(trans_turnover) Turnover
from members
join transact
on mem_number = trans_code
where Trans_date between '&Start' and '&End'
and mem_barred = 0
group by 	mem_number
	order by turnover desc
)
where rownum <=200
/

Please tell me how I fix it.