SQL Builder

The SQL builder only creates SQL SELECT statements.

These records can be used to create Tables used in Reports.

The SQL Builder can also be accessed via the SQL button next to any nuBuilder Forte Textarea Object requiring SQL.

Creating an SELECT Statement

Description

Description of SQL

Field and Relationships

This is a graphical way to create table relationships.

You can add a table by making a selection from Add Table

Each table added has..

• A Tablename.
• A field where the user can enter an alias for this table.
• A list of fields belonging to this table
• A Checkbox at the left of each field name allowing this field to by chosen.
• A Checkbox at the top left allowing all fields to by chosen at once.