UNION in an SQL-SELECT Produces Only Distinct RecordsID: Q102892 The information in this article applies to:
SUMMARYWhen you are using the UNION clause to combine the results of two SELECT statements, the FoxPro implementation of SQL will eliminate any duplicate rows. If you want duplicate rows to appear in the resulting output, include the ALL keyword after the UNION clause. MORE INFORMATIONThe online Help and "Language Reference" manual state the following: Include the UNION clause to combine the final results of one
SELECT with the final results of another SELECT. By default,
UNION checks the combined results and eliminates duplicate rows.
Use the optional ALL key word to prevent UNION from eliminating
duplicate rows from the combined results.
For example, given table A and B, each of which may contain
duplicate records which are to be preserved and combined into a
single cursor, issue the following command:
SELECT * from A ;
UNION ALL ;
SELECT * from B
A and B must contain the same number of columns, and the
corresponding columns must be of the same type.
Additional reference words: FoxDos 2.00 2.50 KBCategory: kbprg KBSubcategory: |
Last Reviewed: April 17, 1995 |
