In iOS i am using sqllite , i have create database with two tables one is for person and second is for person images, i want to get person info with any one image BUT my query is return all image with repeat person id please help me here is my query
SELECT person.id,person.name,person.date,allimages.imagepath,allimages.personid FROM Person INNER JOIN allimages
ON Person.id=allimages.personid
ORDER BY Person.ID
please share your valuable knowledge . In short i don't want to repeat person id
Aucun commentaire:
Enregistrer un commentaire