Using DISTINCT wirh ORDER BY

[Rustywater]

Hi All,

This query results in a conflict.

<cfquery name="sellers" Datasource="#Application.datasource#">
select DISTINCT users.uid_user, full_name from users, member_types, user_roles
where users.uid_user=user_roles.uid_user and
user_roles.uid_role=member_types.uid_member_type and
member_types.is_committee=true
<cfif #session.sequence# is True>
order by first_name, last_name
<cfelse>
order by last_name, first_name
</cfif>
</cfquery>

The user_roles table can have multiple entries for a single user, hence the
use of distinct, but I still want to order the query results. The full_name,
last_name and first_name columns are all from the users table.

How can I do this given DISTINCT and ORDER BY conflict?

[MikerRoo]

Try adding last_name and first_name to the select clause of the query.

[Rustywater]

Thank you. That works.
Tanya