jeudi 26 février 2015

Sqllite query In inner join i don't want to repeat id

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