In this movie, Adam creates a query that includes a nested subquery as a criteria selector. The query displays order details for the customers of H+ Sport, and the subquery identifies the date that the customer last placed an order if they are a returning customer. These types of complex questions are possible with knowledge of SQL.
- [Voiceover] Occasionally, you might find the…technique of embedding an SQL select statement inside of…other queries to be helpful in organizing your data.…Sometimes this is referred to as a subquery…or an inner query or a nested query.…Now whatever you call it, the technique can be…quite useful, so let's take a look at an example.…Sometimes you'll want to include records…in your query based on the results of another query.…Often this may include a calculation…based off of your data, for instance,…I'd like to see some details about our customer's orders…and also be able to see when they placed…their last order with the H Plus Sport Company.…
To do this we'll start a new query in design view…and we'll pull out some information from our…customers table, our orders table and our products table.…From these tables I'll choose the customer ID,…first name and last name.…From the orders table I'll grab the order ID…and we'll scroll down and get the date…and then from the products table…I'm gonna get the item name here.…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.