All joins are driven by the first table which is assumed to be the main fact table. It supports joining on up to eight dimensions. Queries should be designed without join loops and joined in such a way that the joins all flow from the first table or higher level tables.
Example:
SELECT *
FROM a
RIGHT JOIN b ON b.id = a.id
Comments
Please sign in to leave a comment.