LEFT JOIN

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 b
LEFT JOIN a ON b.id = a.id
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.