Build queries with Query Builder
Last modified: July 22, 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 in the FROM clause
- Create subqueries
- Create subqueries in other clauses
- Navigate a query with Document Outline
Was this page helpful?
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.