What is exactly Left Outer Join in Database View
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2025 08:13 PM
I created two tables in Database View like below here:
=> Results returns to me 45,478 records which is normal because it returns matched records and all records in table Resource Aggregate Weekly (raw).
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:
- Results