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

Chapter 17. Getting the Most from Your Queries > Special SQL Specific Queries

Special SQL Specific Queries

While you are in the Design view window of a query, you can click Query and then choose SQL Specific. You will notice three options: union, pass-through, and data definition.

These queries cannot be created in the QBE design window; neither can they be upsized. The pass-through query runs on a server, anyway. You can create these queries directly by choosing Create Query in Design view and then clicking Close when the Show Table dialog box appears. Next, click Query and SQL Specific from the menu. Then choose the query type of your choice to create the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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