Microsoft KB Archive/67509

{| = Q+E Version 2.50 Supports the Keyword DISTINCT =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q67509

SUMMARY
Microsoft Q+E supports the keyword DISTINCT when querying SQL Server tables only. Q+E returns the error &quot;SELECT DISTINCT is not supported&quot; if you use DISTINCT with text or dBASE compatible files.

DISTINCT is used to eliminate multiple instances of identical records. DISTINCT is not available as a menu option; however, you can add it to the SQL query text.

MORE INFORMATION
To add the keyword DISTINCT, use the following steps:


 * 1) Start Q+E.
 * 2) Open the SQL Server table you want to query.
 * 3) Choose Select SQL Query.
 * 4) Insert the word &quot;DISTINCT&quot; (without the quotation marks) just after the word &quot;Select.&quot; DISTINCT may be capitalized or entered in lowercase.
 * 5) Choose OK.

For example:

Original Query
SELECT last_name, first_name, hire_date FROM janitors

After Modification
SELECT DISTINCT last_name, first_name, hire_date FROM janitors
 * }