Advertisement

Joining Tables

  • Mike McQuillan

Abstract

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 table, to list that particular contact’s phone numbers.

Keywords

Phone Number Support Specialist Select Statement Delete Statement Matching Record 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Mike McQuillan 2015

Authors and Affiliations

  • Mike McQuillan
    • 1
  1. 1.WinsfordUK

Personalised recommendations