Refine the query

Pentaho Report Designer

Part Number
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.