| There is several ways of opening the design plane.
File -> New -> Query Design
Toolbar -> New -> Query Design
Crtl - Q |
 |
| Select a table from the tree and drag drop it on the design plane |
|
| If you have mare than 2 tables in the design plane link corresponding fields by drag & drop the field to the corresponding field of the second table |
 |
| Select all the output fields by checking the checkbox of the field name |
 |
| Drag from the table box on the criteria plane the fields for which you need to specify a criteria |
|
|
 |
| You can specify an alias for the table by double clicking the table |
|
| Click the SQL button to generate the SQL. |
 |