O'Reilly logo

Introducing SQL Server by Mike McQuillan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 12

image

Joining Tables

Up to this point, all of our SELECT statements have used the Contacts table. This may seem thrilling enough, but we’re about to take the octane level up to Jason Statham movie territory. The Contacts table we’ve been looking at doesn’t offer us much information—really, just the name and date of birth. If we wanted to phone a contact, how would we identify that contact’s phone number? Based on the approach we’ve used so far, we could write a SELECT to find a record in the Contacts table using FirstName and LastName. From there, we could make a note of the ContactId and then use this to write a SELECT against the ContactPhoneNumbers ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required