课程: Access 2016 Essential Training

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Creating a union query in SQL view

Creating a union query in SQL view

课程: Access 2016 Essential Training

开始一个月试用 购买团队方案

Creating a union query in SQL view

“

- The query design view is exceptionally powerful and it allows you to create a query for nearly any scenario that you can imagine. However, it really is just a front end to something even more powerful that's happening in the background. When you create a query in design view, Access is translating those instruction into code called structured query language, or SQL. You can see the code for the queries you've created by switching to this third view mode, SQL mode. Now I'm not going to be able to get into writing SQL queries here. There are other courses in the Lynda.com library that cover this topic in depth. But I thought it would be helpful for you to get just a taste of what this looks like. I want to walk you through the creation of one query type that you actually cannot create using the design view. The union query is useful for when you want to temporarily join two tables together. Unlike the append query, which permanently copies data from one table and saves it into…

内容