Be able to rename subquery's used in the query builder

Toad Data Point & Toad Intelligence Central Idea Pond
1

Be able to rename subquery's used in the query builder.
At this moment the name is automatically created without an option to change the name.

Query --> Subquery --> Subquery_1 --> Subquery_2 --> Subquery_3

2

I realize that this is several years old...might help someone searching later.

This can be done...

  1. Setup the subquery.
  2. Go to the query that it will be joining to.
  3. Add any field from the subquery to the query (even if you don't intend to return this field...temporarily add it).
  4. Go to the settings for this field and change the Table Alias from Subquery to the desired name.
  5. The field can be removed from the select list, if desired, subquery is now aliased.