Database views: Using a Join

• Default inner join - Returns matching records
• Left Join - Includes all incidents

Creating a database view

• Create a database view by specifying the link between the tables to create a virtual table.
• The default behavior is to show only the results where both of these items have values (e.g. incident_problem_id = problem_sys_id).
• A left join causes the view to include all Incident records, even those that do not have an associated problem record.

NOTE: The default JOIN for a Database View is referred to as an INNER JOIN.

Creating a left join view

• To create a database view with a LEFT JOIN, configure the View Table form layout to display the Left join field.