Creating a Query

To create a query

Choose Components > Query from the HPL main window.
The Query window appears, as Figure 76 shows.
Click Create in the Selection Type group.
Choose a name for your query and type it in the Query text box.
In the Database text box, type the name of the database that contains the tables from which you want to extract data, or click the down arrow to select from a database selection list.
Figure 76 shows the Query window with the Query text box completed and stores_demo selected from the selection list.

Figure 76. The Query Window
Click OK.
The query-definition window appears, as Figure 77 shows. The name that you chose for your query appears in the title bar.
Type your query in the Select, From, and Where text boxes.
Figure 77 shows the following simple query of the customer table of the stores_demo database:
```
SELECT customer.fname, customer.lname, 
   customer.zipcode
FROM customer
WHERE zipcode > 50000
```
If you prefer, you can type the entire query into the Select text box. If you later edit the query, ipload divides the query into SELECT, FROM, and WHERE clauses.

Figure 77. The Query-Definition Window
Click OK to save the query and return to the Query window.
The query that you just created now appears in the Query list box at the right-hand side of the Query window.
Click Cancel to return to the HPL main window.