Tuto WEBDEV 25

170 Part 5: Let’s continue the development Let’s take a look at the interface of query editor: This interface includes: 1. an analysis reminder (the description of project database). 2.  the items that will be included in the query. 3.  the options for selecting records. 4.  the query in SQL code or in natural language. ▶ To build the query, we are going to select the elements that will be displayed in the result. 1. Double-click the items found in the analysis on the left of description window. The items taken into account are displayed in the middle of the screen. We want to display: • information regarding the order. In the "Orders" data file, double-click on the items: OrdersID, Date, Status and TotalIOT. • information regarding the customer who placed the order. In the "Customer" data file, double-click on the "FullName" item. • information regarding the payment mode of order. In the "PaymentMode" data file, double- click on the "Caption" and "PaymentModeID" items.