that will still give a left join, look at the counts of tables and the count of the join produced in the view,

Servicenow uses MySQL as database and MariaDB as a driver / interface

looking at MariaDB there is only a possibility of doing a cross join (eventually then e.g. for Reporting define the joins in a filter ), and I do not see such possibility in the Servicenow UI

Please correct me if I'm wrong.