Previous Topic

Next Topic

Book Contents

Book Index

Build Query Column

Use this Window to build or modify an individual Query Column. You open this window by clicking on NEW or MOD in the GUI Columns tab.

query_builder_cols2

Summary Query

If you are building a Summary Query, the Function list will just be the aggregate functions (sum, avg, min, max).

Specifying a Query Columns as a Literal or System Variable

You can specify a literal, expression or system variable, by checking the Query Column is a literal box.

You can also use this method for specifying a sub-select or case statement. For large expressions such as these,click on the >>> for a larger box.

AQT provides no assistance for building a sub-select or case, though this may be done in a later release.

query_builder_cols3

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.