Using Multiple Instances of Dimension Tables in the FROM Clause

The same dimension table can appear multiple times in the FROM clause of a query, using different aliases. For example:

SELECT *

FROM fact, dimension d1, dimension d2

WHERE fact.fk = d1.pk

AND

fact.name = d2.name