To join tables:
FROM XMLTEST.VIDEOS AS V JOIN XMLTEST.RENTALS AS R JOIN XMLTEST.CUSTOMERS AS C ON R.CUST_ID = C.CUST_ID ON V.VID_ID = R.VID_ID
In the Tables pane, both joins have been created as shown here:
You can change the join type (for example, from the default inner join to a left, right, or full outer join) in the Tables pane by right-clicking the connector, clicking Specify Join Type on the pop-up menu, and then selecting the join type that you want in the Specify Join window.
To create a query condition:
To add a GROUP BY clause: