SELECT * FROM Contacts; SELECT * FROM Contacts JOIN EmailAddresses ON Contacts.contactId = EmailAddresses.contactId; SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId;