Name the available views to see the query window.....
AND
Name the type of queries available in access.......
Answers
Answer:
The Choose Table or Specify Query window displays when you select an input containing multiple tables. You can select tables and construct queries to pull data from relational databases.
Alteryx Designer uses Active Query Builder, a third party component for building complex SQL queries. For more information, see the Active Query Builder User's Guide.The Tables tab displays all of the tables and views contained within the specified relational database. To refresh the cached list of tables, click Refresh. To select a table:
Select a table/view in the list.
Click OK to open the table, or select another tab to build a query directly from this table/view.
You can also bypass this tab and proceed to the subsequent tabs to build a query utilizing multiple tables/views