Query Property Sheet Tables Tab

This tab lists the tables in the FROM clause, which specify where the query data will be drawn from.

You can add or delete tables as appropriate, and reorder the tables in the list using the arrows at the bottom of the tab. Any changes you make will propagate to the query's SQL tab and to the SQL Query tab of the parent view.

  1. Click in the first empty row in the list.
  2. Select a table from the list. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.
  3. [optional] Enter an alias for the table in the Alias column.
  4. [optional] Select a join keyword and a second table, choose an appropriate join condition keyword, and then specify the join condition. Select additional tables and join them as necessary.
Parent topic: Working with View Queries