Select the Modeler button. Create a new SQL View called V_CUSTOMER_ISSUES
by selecting Create New tile in Views.

Select View Type SQL
and name it V_CUSTOMER_ISSUES
.

Once the view is created, the next step is to add Data Sources (two tables from previous steps). Click on the Add Data Source button. You can start typing the table name or supply a *
to list all known Data Sources as shown below.

Repeat to add second table.

Continue by selecting desired columns as output by clicking on the highlighted radio buttons next to each required column. Note that the selected output columns will appear in the right hand pane Columns.

Join the two tables on the common column COMPLAINT_ID
. First use your mouse pointer to select the COMPLAINT_ID
column in the PRODUCTS
table. Hold the mouse button down while dragging it to the COMPLAINTS_DISK
table and drop it on the COMPLAINT_ID
column.

The Join Definition window appears. Change the type to Left Outer
and select OK when done.

Save the view. Now preview what you have done so far by clicking on the Preview button as demonstrated below. Note the join linking the two tables.
