Use the Query Designer to build complex queries across multiple tables without writing any code.
SQL Server Management Studio includes the Query Designer to assist in building queries. It is a visual tool that allows you to select the tables and columns you want in your query, as well as any filtering criteria.
No need to write any SQL code — the Query Designer will generate that for you.
Use the Query Designer to Build a Simple Query
We'll now use the Query Designer to build a simple query. If you've been following along in this tutorial, you'd now have a database with three tables — all of which contain data. And because we've established a relationship between these tables, we can now run queries across all three, returning related records.
Open the Query Designer
Add the Tables
Design the Query
Make sure you keep this query open in the query window because next, we will save it as a view.