WebFOCUS Online Help > Managed Reporting Developer > Creating Reporting Objects > Joins
A join is a temporary connection between two or more data sources that share at least one common field. After you join two data sources, each time WebFOCUS retrieves a record from the first data source (host file), it also retrieves the matching records from the second data source (cross-referenced file). For a full description of joining data sources using the browser, see the Creating Reports With WebFOCUS Language manual. For a full description of joining data sources using Developer Studio, see the Creating Reports With Graphical Tools manual.
You use the Join Tool to link data sources. The Join Tool provides a graphical method for creating and manipulating joins. Instead of coding a join using the WebFOCUS language, you use the Join Tool to drag a field from one data source and link it to a field in another data source.
When you access the Join Tool, the window displays a field list for the data source associated with the Reporting Object (which you specified when you created the Reporting Object) and a field list for any data source you add to the window. An icon representing the data type appears before each field name in the Master File.
Note: When joining two FOCUS data sources, the cross-referenced file field must be indexed.
WebFOCUS |