Creating visual queries in the Query Builder editor
You can use the Query Builder editor to create visual queries. You supply table, join, column, sort, and row information and the editor constructs the SQL statements.
About this task
To create a visual query in the Query Builder editor, you must add tables. Then you can add joins to them, to specify particular table fields, add row and global conditions, to edit the SQL text of the created query, or add multiple SQL statements to the query: