• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Querying with SQL Statements > Using SQL to Create Union Queries

Using SQL to Create Union Queries

A union query is another SQL-only entity. It enables you to combine the dynasets of two or more SELECT statements into a single dynaset. Here's the general syntax:

SELECT statement1
UNION SELECT statement2
[UNION SELECT statement3...]
ORDER BY field_list [ASC | DESC];


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint