What is exactly Left Outer Join in Database View

sieusaopolo15
Giga Sage

I created two tables in Database View like below here:

sieusaopolo15_0-1742007871209.png

=> Results returns to me 45,478 records which is normal because it returns matched records and all records in table Resource Aggregate Weekly (raw).

sieusaopolo15_1-1742008026114.png

 

Then, I updated the Left Outer value of resource_aggregate_weekly table to true and time_card to false. I should think it will give the same result because in this Document that Joined tables are ordered left to right from lowest to highestOrdervalues but it gives different result it's not 45,478 anymore it is 1,785. Do I configure something wrong or am I not understanding this correctly ?

- Updated table views:

sieusaopolo15_2-1742008294453.png

- Results

sieusaopolo15_4-1742008314066.png