SELECT contactPhoneID, contactName, contactNumber, contactNumberType,
contactEmail, contactImage, contactSortKey, contactCountryCode,
contactRingTone, contactStatus, contactTimeStamp, contactMoodName,
contactMoodType, contactEmotiUserFlag, contactSpeedDialID,
contactSpeedDialFlag, contactFavorites, GROUP_CONCAT(contactNumber) AS contactNumber,
contactName
FROM CONTACT_TABLE
WHERE contactFavorites = 'TRUE'
GROUP BY contactPhoneID
hello getting error where clause adding beside this its working perfectly
Aucun commentaire:
Enregistrer un commentaire