ORDER BY clause (Item) conflicts with DISTINCT.

Error 3093

You created an SQL statement29F05E5 that has a ALL, DISTINCT, DISTINCTROW Predicates (SQL)JQ3FN7 and an ORDER BY Clause (SQL)15DW835 that contains a field not listed in the SELECT Statement (SQL)ZUPF0W.  Remove the DISTINCT reserved word43US84, or remove the specified field from the ORDER BY clause.