Linking datasources with advanced queries
The data item property DataItemLinkType specifies how the tables will be joined in the query. Besides two basic types, there is an option that allows the developer to enable advanced options and perform right outer joins, full outer joins, and cross joins.
How to do it...
In this recipe , we will build a Query object with full outer join between two tables to see detailed information on customer discount groups configuration:
Create a Query object in object designer.
Insert a data item with the Customer table as data source.
Include two columns from the Customer table: No. and Name.
Add another data item Customer Discount Group.
Include two fields from the Discount group: Code and Description:
Open the properties for customer discount group data item and choose SQL Advanced Options in the DataItemLinkType property.
The new property, SQLJoinType will become available. Select FullOuterJoin.
Open link editor in the DataItemLink property and configure the link...