Hi everyone,
we're having a spot of trouble with a query.

As you can see below we're selecting data from a view using distinct and
order by...

SELECT DISTINCT activity_id, activity_date
FROM VIEW_NAME
ORDER BY activity_date ASC, activity_label

This doesn't return rows ordered by activity_date...

Little help?

Cheers,
Adam Thick.

--
Adam Thick

Strategic Data Pty Ltd

Ph : +61 (3) 9348-2013
Fax: +61 (3) 9348-2015
Mob: 0404 032 763
Email: Adam.Thick@...
Web: http://www.StrategicData.com.au/
Post: P.O. Box 4262
Melbourne University, VIC 3052
Australia