Subversion Repositories Sailfish_Contacts_Restore

Rev

Rev 16 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

SELECT * FROM Contacts;
SELECT * FROM Contacts JOIN EmailAddresses ON Contacts.contactId = EmailAddresses.contactId;
SELECT * FROM Contacts JOIN PhoneNumbers ON Contacts.contactId = PhoneNumbers.contactId WHERE Contacts.contactId=42;
SELECT * FROM PhoneNumbers JOIN Details ON Details.detailId = PhoneNumbers.detailId;
SELECT * FROM PhoneNumbers JOIN Details ON Details.detailId = PhoneNumbers.detailId WHERE PhoneNumbers.contactId=42;
SELECT * FROM Contacts JOIN Addresses ON Contacts.contactId = Addresses.contactId WHERE displayLabel LIKE '%oduma%';
SELECT * FROM Addresses JOIN Details ON Addresses.detailId=Details.detailId WHERE Addresses.contactId=7;
SELECT * FROM Organizations WHERE contactId = 7;
SELECT * FROM EmailAddresses JOIN Details ON Details.detailId= EmailAddresses.detailId WHERE EmailAddresses.contactId = 8;
SELECT * FROM PhoneNumbers JOIN Details ON Details.detailId = PhoneNumbers.detailId WHERE PhoneNumbers.contactId = 8;
SELECT imageURL FROM Avatars WHERE contactId = 8;