Edit

Create Queries

Create queries with query builder

Supports :

This is how you create queries with query builder

1. Connect to database.
2. On the main menu bar, click File>New>Query Builder. Or simply click [Query Builder] on the Toolbar. It will open an blank document.

3. On Object Panel, select tables and views needed for query and drag them to Query Builder window.
4. Select fields to view.
5. Select related fields and drag them into a different table field.
6. To add constraint clause, click ... >Add condition on the lower tab.

7. Click [Run] or press F5.
8. On Result, check the query result.

9. On the SQL tab, view the generated SQL query statement.

Tip : To give alias to a table, double click the name of the table and enter alias.