The Draw Query dialog box opens.
Patterns enable you to search for table names from a list of matching tables. There are two types of search patterns:
Use the percent character (%) to match a string of any length containing any characters. For example, to list all tables with a name beginning with the letter A, enter A%.
Use the underscore character (_) to match a single character. For example, to list all tables with an owner that has the letter A in the second position, enter _A%.
The table is added to the query.
The SQL for the selected table or tables is created and displayed. You can edit the SQL.