Date collegate

Retrieving dates linked to values

In the previous query, dates were directly linked to the items we selected. But dates are not always directly linked to the items of interest to us. Once you have learned to retrieve data linked to values, it is quite easy to retrieve date information related to items. For example, the following query shows the date of birth of the directors of the Star Wars movies on a time scale:

Note the query uses the DISTINCT modifier to remove duplicates from the results.

Skip to content