From the course: Learning Azure SQL Querying

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Joining together multiple tables for increased query results

Joining together multiple tables for increased query results - Azure Tutorial

From the course: Learning Azure SQL Querying

Start my 1-month free trial Buy for my team

Joining together multiple tables for increased query results

“

- [Instructor] Let's also pull in the product category. In the select column list after name, type product category ID and then delete the previous where and order by statements. In the result, the product category ID will be an integer so you'll need to go to the product category lookup table and see what product category ID 18 is equal to. We can write a second query to do that real fast. Underneath your existing query, type select name from product category and then click on the full table name that auto completes. And then without pressing enter, just type space where product category ID equals 18. You don't have to put different keywords of the SQL statements on new lines. The SQL engine doesn't really care about how you separate the keywords as long as there is at least one space between them. But you'll sometimes see the keywords separate onto new lines, and that's only to make it easier for you to read. Highlight…

Contents