The NATURALLEFTOUTERJOIN function creates a new table from two other tables – using the Left Outer Join.

How to do it?

Let´s have two connected tables:

New table can be created using the NATURALLEFTOUTERJOIN. It will have all rows from the left table (the fact table) and connected rows from the dimension.

  • Table = NATURALLEFTOUTERJOIN(People;’Heads of departments’)

Leave a Reply

Your email address will not be published.


clear formPost comment