Insert Query command

Choosing the required tables (Insert menu) or Table tab (View menu)

See also:

$image\tables2.gif$

Selecting the required tables in a list:

Once the table list is displayed in the most right and upper window, you can make a double-click on the table you want to add in the Tables Tab, or you can do it making a drag and drop.

Note: this concerns the first table, double-clicking a table enables the user to go directly to the Query tab and run a query with all the fields in the table automatically selected when the command Query> Run is activated. (This is a new feature from Version 5.00 onwards).

Adding a table manually (new since version 3.11): you can also add a table entering manually the full path and table name to avoid to search in a list that can take time to run. To do so, make a right mouse click in Table Tab bottom window then select the command <Add a table>.

Going to the Query tab: once the required tables are selected and the required join statements defined, click on the <View> <Query> command or on the Query tab to build your query.