My Structured Query Language

Lesson 3

Table with Relationship


Above is altered table for my Address List

Created Two Related Tables


I don't know that this is working as I expected. I added a 'family' to my address list (as seen as the bottom record) but entering the family_id did not return in the list the family_name. So should have it. Or is this something that is revealed in a Query. It seems to me that it did not make "myaddress_list" simpler.