In the example below, the package contains 2 data sets.
|
We can run the following query against the first data set to summarise total orders to date grouped by territory. The results of the local query is then displayed, and marked as local SQL to indicate that it is a data set generated from a local SQL query.
|
When you run a local query, the first data set is referred to as ds1, the second data set as ds2 and so on.
You can also join multiple data sets using standard SQL constructs like INNER JOIN and OUTER JOIN. The next query uses data from the 2 data sets, to return the name of all products sold in Australia, together with each product's thumbnail photo.
|