Sailfish_Contacts_Restore/SQL/Abfragen.sql

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 Addresses JOIN Details on Details.detailId = Addresses.detailId where Addresses.contactId = 6;