SELECT * FROM Contacts; SELECT * FROM Contacts JOIN EmailAddresses ON Contacts.contactId = EmailAddresses.contactId; SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId; SELECT * FROM Contacts JOIN Addresses ON Contacts.contactId = Addresses.contactId WHERE displayLabel like '%oduma%'; SELECT * FROM Addresses JOIN Details on Details.detailId=Addresses.contactId WHERE Addresses.contactId=5;