Refine the query

Pentaho Report Designer

Version
10.0.x
Audience
anonymous
Part Number
MK-95PDIA008-05
Depending on how you might want to further refine your query, you can perform the following steps to join tables, apply conditions, or group and order rows:
  1. To create an SQL JOIN between tables, select a reference key in one table, then drag it to the appropriate row in another table.
    To modify the JOIN, right-click its red square, then click edit in the popup menu.
  2. To add a condition or expression, right-click a row in the query workspace, and select the appropriate action from the menu.
  3. To order or group by a specific row, drag a statement from the SELECT category in the upper left pane and drop it into the GROUP BY or ORDER BY category.