Build queries with Query Builder

Last modified: May 28, 2025

This section describes how to create and manage SQL queries visually using Query Builder in dbForge Studio. It explains how to add and join tables, define conditions, and build queries using WHERE, HAVING, GROUP BY, and ORDER BY clauses. It also covers working with diagrams, managing subqueries, and using keyboard shortcuts to navigate and organize complex queries efficiently.

In this section

Query Builder overview

Add tables to a query

Remove tables from a query

Include columns in a query

Join tables automatically

Join tables manually

Create joins between tables

Build WHERE and HAVING clauses

Include fields in GROUP BY and ORDER BY clauses

Build a query in visual mode

Work with different query types

Query Builder diagram overview

Query Builder diagram layout

Align shapes

Change shape sizes

Control spacing between shapes

Query Builder diagram shortcuts

Focus and selection shortcuts

Zoom and scroll shortcuts

Shape and column management shortcuts

Create subqueries

Create subqueries in the FROM clause

Create subqueries in other clauses

Navigate a query with Document Outline