Hi Fabio,
Until I saw the example you sent me I didn't know I could join to a subquery. All I had to do was strip out the 'order by' clauses and it worked. Thanks!
Margaret.