Support for full outer join in Servicenow database views

[rajranbhare]

Hello,

I want to have a full outer join in servicenow database view. There isn't any documentation available for that. Does servicenow supports outer join? If yes, how? And If no, how can I achhieve that?

Thanks

[rrataj]

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

looking at MariaDB there is only a possibility of doing a cross join ( and 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. 

[Aviv S_]

Hi

did you solved this?

[steveessery]

There is no support for Full Outer Joins.  If not specified the joins are inner joins unless you select/click the Left Join option.  See:

https://docs.servicenow.com/bundle/orlando-platform-administration/page/use/reporting/task/example-l...