Creating a select statement
We want to retrieve a customer name and the total amount of money involved in each transaction type (credit, debit).
To create the select statement:
| In the Data Project Explorer view, right-click the SQL Scripts folder in the RAD75DataDevelopment project and select New Æ SQL or XQuery Script. |
|
| In the Script Name and Editor page, enter CustomerTransactions as the name. Select SQL Builder as the editing tool and SELECT as the statement type . |
Figure 11-7 New SQL and Editor page
|
| Click Finish and the SELECT statement template is created and opens in the SQL builder . |
Figure 11-8 SQL Builder
|
ibm.com/redbooks |