Jump to content

Set operations (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 67.52.10.155 (talk) at 18:32, 7 October 2005. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

UNION

Combines the results of two or more queries into a single result set consisting of all the rows belonging to all queries in the union.

    ©1988-2000 Microsoft Corporation. All Rights Reserved.

Also:

  • Duplicates are removed.
  • The two queries must have matching fields and data types inorder to join them.