SQL$HELP72.HLB  —  Errors  SQL_ERRORS, NONSTADIS
  The standard only permits one DISTINCT clause in a select
  expression

  Explanation:  You entered a select expression which either has
  two aggregate functions with DISTINCT clauses, or has a DISTINCT
  clause for the entire select list and a DISTINCT in an aggregate
  function.  The ANSI and ISO SQL standards do not support
  multiple distinct clauses.

  User Action:  If it is important to have only standard features
  in your program, you should remove one of the distinct clauses.
Close Help