Reason:
You cannot specify DISTINCT/UNIQUE when your query contains a UNION ALL clause. These two clauses contradict each other: DISTINCT/UNIQUE strictly enforces uniqueness within rows while UNION ALL strictly enforces all duplicate rows to be displayed.
Module:
OLQSPSQL
Severity:
0
|
Copyright © 2014 CA.
All rights reserved.
|
|