User's Guide

Building queries

Index  Next

Active Query Builder is a visual query builder component that allows you to build complex SQL queries via an intuitive visual query building interface.

To work with Active Query Builder, you need basic knowledge of SQL concepts. Active Query Builder will help you to write correct SQL code hiding technical details, but only understanding of the SQL principles will make it possible to achieve desired results.

This Guide will help you to learn basic principles of visual building of SQL queries to achieve best results while working with Active Query Builder.

Here are the steps of building an SQL query using Active Query Builder:

• Getting started
• Building a single query
  • Adding objects to the query
  • Setting object aliases
  • Joining tables
  • Selecting output fields
  • Sorting a dataset
  • Defining criteria
  • Grouping output fields
  • Defining SQL query properties
• Building a query with sub-queries
  • Navigating the query tree
  • Working wih sub queries
  • Working with derived tables
  • Working with unions

Index  Next