Left Join in creating database view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2018 01:24 PM
Hi -
I'm trying to create a database view with a left join and I'm a little confused by the results I'm getting and questioning what "Leftjoin = true" means.
What I'm try to create would be similar to writing a SQL query:
Select * from sys_user as u
left join u_integration_definition as id
on u.sys_id = id.u_user
What I expect is all records from the sys_user table.
I thought what I built below would get the results I wanted:
but I only get integration records (table u_integration_definition). It's not until I flip the True/ False values on the tables where I would get all sys_user records. Why is that? I assumed that by selecting LeftJoin = true on the sys_user table, the sys_user table is the left table. I am now confident I have no idea what "Left Join = true" means.
Thank you!
- Labels:
-
Personal Developer Instance
- 10,713 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-21-2018 07:44 AM
Once check the below link. It may help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-21-2018 07:54 AM
Thank you for your reply.
So, I read this and I still feel that my initial attempt (image in my original comment) should have given me my expected results.
- Selecting Left join causes the left-hand table in the database view to display all records, even if the join condition does not find a matching record on the right-hand table. Select this check box for view tables that specify a Where clause. Selecting Left join for view tables without a Where clause does not affect the query. >>> Left Join = true is set on the sys_user table
- Joined tables are ordered left to right from lowest to highest Order values. >>> Order on sys_user table = 100 (the lowest value)
Could you help me understand why my database view doesn't work?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2021 02:10 AM
I am also facing the same issue.Can someone assist?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2022 02:41 AM
I am also encountering the same, till I discovered the same "swapping the left join check box is actually working"
It would have been great, if we could somehow view the sql query that is getting generated while joining the tables.