LCL006 - Build, Execute and Save a Linked Query
A linked query is made up of two or more queries linked together. This allows the results of one query to be used as the selection criteria for another query, giving you the ability to drill down into your data only when you want to. With linked queries, you don't have to retrieve large amounts of data in case you may want to look at the details of a particular item.
In this tutorial you will create a query to obtain a list of Products. From this query you will randomly select a product and then you will Run the Linked Query as a Sales by Product query to obtain the sales of the selected product.
To do this you must perform these steps:
Step 1. Create the first query
Step 2. Select the fields for the query
Step 3. Define the link for the second query