Specifying the data to retrieve
When you create a JDBC Database Connection for Query Builder data source, as described in the previous section, you have access to the SQL query builder. This graphical tool provides access to your database schema and objects, and wizards that help you select and join tables, sort, group, and filter data.
How to create a query using the query builder
1  
2  
1  
In Data Source Selection, select the JDBC Database Connection for Query Builder data source to use. Data Set Type displays SQL Select Query [Query Builder].
2  
3  
The query builder appears, as shown in Figure 2-3. The top pane displays a SELECT statement. You can type a query here, or use the tools in the middle and bottom panes to create the query. The rest of this procedure describes the steps for creating a query graphically.
Figure 2-3  
3  
1  
2  
3  
4  
4  
1  
2  
In Create Join, specify the tables and columns to join, and the join type. Figure 2-4 shows an example of an inner join on the CUSTOMERNUMBER columns in the CUSTOMERS and ORDERS tables.
Figure 2-4  
3  
Repeat the previous steps to join all the tables. Figure 2-5 shows three tables that are joined. The SELECT statement in the top pane is updated to reflect the selected columns and table joins. The bottom pane lists the selected columns and their properties.
Figure 2-5  
5  
*
*
*
*
The following sections provide more information about each task.

Additional Links:

Copyright Actuate Corporation 2012