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. |
|