Glossaria.net

Glossary Visual Basic / Term

union query

union query

An SQL-specific select query that creates a snapshot-type Recordset object containing data from all specified records in two or more tables with any duplicate records removed. To include the duplicates, add the keyword ALL.

For instance, a union query of the Customers table and the Suppliers table results in a snapshot-type Recordset that contains all suppliers that are also customers.

Permanent link union query - Creation date 2020-06-07


< Unicode Glossary / Visual Basic universal date format >