This document introduces the basics of using the Query Builder Tab , and describes its main features.
The Query Builder is a visual SQL query builder allowing end-users to build complex SQL queries via an intuitive visual query building interface.
The Query Builder is a perfect choice for both SQL beginners and experienced query writers. It displays all SQL features such as; parent-child table unions (INNER, LEFT, OUTER and FULL JOINS), tables list, field lists and a results list. Its very easy to accomplish complex queries and provides the end-user with everything he or she needs to efficiently work with SQL queries. The interface is similar to MS Access and SQL Server’s visual query building interface, so it is already familiar to most database users.
The Query Builder practically eliminates mistakes when writing SQL queries while achieving almost instant results in your reports.