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 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;