Query Properties

Select Query Properties from the Edit menu to display the Query Properties dialog box. Use these options to specify properties for the query you are currently writing. To specify these properties for all queries (and not just the current query), use the Global Options dialog box.

Build full-qualified SQL statement. Select the Build full-qualified SQL statement check box to display the full-qualified SQL statement when you choose to view the SQL statement. This means that the specific database name and/or path will be included in the SQL statement. If this check box is not selected, then the data will not be included in the SQL statement. You can view the SQL statement by selecting the SQL Statement tab or by switching to Text mode (by toggling the toolbar button or the Graphic Mode option on the View menu).

Quote catalog names/Quote schema names/Quote table names/Quote field names. These options determine whether references to database objects in the SQL statements generated are to be enclosed in quotation marks. For most database drivers, the default setting is applicable. For certain drivers, placing catalog, schema, table, and field names in quotation marks causes an SQL error. If you do not want quotation marks around these names in the SQL statement, clear the check boxes. You can view the SQL statement by selecting the SQL Statement tab or by switching to Text mode (by toggling the toolbar button or the Graphic Mode option on the View menu).

Use ANSI join syntax. If you need ANSI-92 join syntax on queries, select this option. By default this option isn't selected. ANSI-92 allows you to use INNER JOIN and OUTER JOIN syntax on the FROM clause. Some databases may require this option.