reforming query for 7.0.2

Hello,

how do I reform this query to work with 7.0.2?


select * from personen join (select count(personen_id), personen_id from
orders group by personen_id) as ordertemp on personen.personen_id =
ordertemp.personen_id

If the table structure is needed I will happily post it here. Although I
don't think it is.

TIA

Markus Bertheau