query is created. (vii) Click at row of grid to specify the sort order (Ascending or descending) on field(s). The selected fields for sort order are shown after ORDER BY clause of SQL statement in which ascending order is the choice by default. (viii) Click at row to check for the selected field to be displayed in the query result.
The field(s) may be selected only for the purpose of specifying the sort order or criteria. Click at row of the grid to specify the criteria to limit the records to be displayed by the query being created. The specified criteria result in a conditional expression, which is shown after the WHERE clause of SQL statement. Click File % Save (or Press Ctrl+S) to save a query.
A dialog box prompts the user to specify the name of the query being created. By default a generic name appears which can be accepted or rewritten with a desired name. (c) SQL View Method : A query may be directly specified in Select Query Pane by a right click at table pane % SQL view. The upper and lower panes of selected query window are substituted by a pane to specify the SQL statement that is written by using keyboard.
The desired SQL statement is directly okeyed in on this pane and saved in the same manner as described for design method. While forming the SQL statement, the following clauses are normally used for generating information (or Select) queries : (i) SELECT : This clause is used to specify the fields to display data or information. Consider the following SQL statement segment : SELECT Code, Name, Amount The fields Code, Name and Amount after SELECT clause indicate the data items to be displayed by the query statement. (ii) FROM : This clause is meant to indicate the source of data in terms of tables or queries or a combination of both.
Two tables are joined by specifying a JOIN clause based on a condition of Join. There can be three types of Join: Inner, Left and right. (iii) INNER : This