https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/102892&feed=atom&action=history
Microsoft KB Archive/102892 - Revision history
2024-03-28T21:31:07Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/102892&diff=262678&oldid=prev
X010: Text replacement - """ to """
2020-07-20T08:36:00Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:36, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17">Line 17:</td>
<td colspan="2" class="diff-lineno">Line 17:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The online Help and <del style="font-weight: bold; text-decoration: none;">&quot;</del>Language Reference<del style="font-weight: bold; text-decoration: none;">&quot; </del>manual state the following:</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The online Help and <ins style="font-weight: bold; text-decoration: none;">"</ins>Language Reference<ins style="font-weight: bold; text-decoration: none;">" </ins>manual state the following:</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre> Include the UNION clause to combine the final results of one</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre> Include the UNION clause to combine the final results of one</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/102892&diff=47392&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:02:55Z
<p>importing KB archive</p>
<p><b>New page</b></p><div>{|<br />
|width="100%"|<br />
= UNION in an SQL-SELECT Produces Only Distinct Records =<br />
<br />
'''ID: Q102892'''<br />
<br />
The information in this article applies to:<br />
<br />
* Microsoft FoxPro for MS-DOS, versions 2.0 and 2.5<br />
<br />
== SUMMARY ==<br />
<br />
When you are using the UNION clause to combine the results of two SELECT statements, the FoxPro implementation of SQL will eliminate any duplicate rows.<br />
<br />
If you want duplicate rows to appear in the resulting output, include the ALL keyword after the UNION clause.<br />
<br />
== MORE INFORMATION ==<br />
<br />
The online Help and &quot;Language Reference&quot; manual state the following:<br />
<br />
<pre> Include the UNION clause to combine the final results of one<br />
SELECT with the final results of another SELECT. By default,<br />
UNION checks the combined results and eliminates duplicate rows.<br />
Use the optional ALL key word to prevent UNION from eliminating<br />
duplicate rows from the combined results.<br />
<br />
For example, given table A and B, each of which may contain<br />
duplicate records which are to be preserved and combined into a<br />
single cursor, issue the following command:<br />
<br />
SELECT * from A ;<br />
UNION ALL ;<br />
SELECT * from B<br />
<br />
A and B must contain the same number of columns, and the<br />
corresponding columns must be of the same type.<br />
</pre><br />
Additional reference words: FoxDos 2.00 2.50 KBCategory: kbprg KBSubcategory:<br />
|}<br />
<br />
{|<br />
|width="100%"| <br /><br />
Last Reviewed: April 17, 1995<br /><br />
<span>© 1999 Microsoft Corporation. All rights reserved. Terms of Use.</span><br /><br />
|}</div>
3155ffGd