Getting Data From Multiple Tables Sqlite

I have an android application that has 2 tables, one table stores posts and the other table stores images of the posts incase it has an image, changes are not all posts will have i

Solution 1:

ok, you asked, so give this a whirl, see if you like the output

SELECT pt.post_id, pt.post, pt.post_description, im.imagePath 
FROM PostTable pt
leftjoin ImageTable im
on im.fk_postID=pt.post_id

It will bring along for the ride the right table (ImageTable) of those posts that don't have images.

Uses table aliases (pt and im). That helps to be explicit which table the columns come from on the first line in case there are common column names in both, plus a little less typing.

Untested

reference Mysql Left Joins

Solution 2:

Try using Left join and that will result all entries from left table and matched entries from right table.

SELECT posttable.postid,posttable.post,posttable.postdescription, imagetable.imageid,imagetable.fkpostid,imagetable.imagepath
FROM posttable
LEFT JOIN imagetable
ON posttable.postid=imagetable.fkpostid
ORDERBY posttable.postid; 

Code should look like that.

http://www.w3schools.com/sql/sql_join_left.asp