Within a Story, you create a query using the Basic User Information table.

Join Types in Queries:

Inner Join:Only returns rows where there is a match in both tables.

Left Outer Join:Returns all rows from the left table and matching rows from the right table, filling in NULLs where there is no match.

Scenario:

Adding the Proxy Information table creates a situation where some records from the Basic User Information table no longer match with Proxy Information.

Changing the join type toLeft Outer Joinensures that all records from the Basic User Information table are included, regardless of matching Proxy Information.

Steps to Adjust Join Type:

Edit the query.

Locate the join between Basic User Information and Proxy Information tables.

Change the join type fromInner JointoLeft Outer Join.