Looking at the table pane
The upper portion of the SQL designer, the table pane, is where tables and fields are depicted. This area lets you select and deselect data for your queries. You can also use these table listings to quickly create joins.
About the table boxes
Each table appears as a scrolling, sizable, collapsible window containing a header with the table name and a list box containing all of the table’s fields.
Next to each field and table name is a check box. If a table name has a dark blue check mark, all fields from that table will be in the query. Otherwise, only fields that are checked will be in the query. If at least one, but not all, fields are checked, the table name will have a light gray check mark.
Dragging the mouse over a table window shows you the full name of the table. For example, the full name for a customer table might be ":mydb:Customer.dbf".
To view tables in a collapsed mode where only the table name appears, click on the minimize button next to the table name.
Tables can be joined by dragging a field from one table window to a field in another table window. When two tables are joined, a join line appears that links the joined tables. For more information on joins, see Creating joins.