At 11:25 AM 23/03/2006, you wrote:

>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?

Ummm...is activity_label actually a column in the view?

What happens if you either 1) take out activity_label from the order
by clause or 2) add activity_label to the select list?

./heLen