From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

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

Join related tables

Join related tables - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial Buy for my team

Join related tables

“

- [Instructor] No discussion about SQL SELECT statements would be complete without talking about how to view information from across multiple tables. This involves adding a JOIN to our FROM clause in the SQL SELECT query. I'd like to review the data that we have in the Landon Hotel by starting up a new query here and make sure that we've selected the LandonHotel in the dropdown menu there. Now I can run three different SELECT statements all at once to review the data that's in the Guest table, the Room Reservations table and the Rooms table. When I execute this query, I really get three different results windows down below. Now if you're not seeing all three of them, you can click here, right below the scroll bar. You'll get this double-headed arrow and you can click and drag it up on your screen so you can see all three. These results windows will be in the same order that we selected them up here in the query. So I…

Contents