SQLite query not working in iphone

i have two tables as follows

CREATE TABLE messageTable (ID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, USERID INTEGER, FROMUSER TEXT, TOUSER TEXT, MESSAGEBODY TEXT, STATUS INTEGER, CREATEDTIME TEXT);

and

CREATE TABLE chatPersonTable (ID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, USERID INTEGER, NAME TEXT, IMAGEURL TEXT, LASTACTIVE TEXT, LOGEDINUSERID INTEGER, STATUS INTEGER);

i want to fetch all columns from chatPersonTable for LOGEDINUSERID = "119" along with the lastMessage (only last message) from messagetable for chatPersonTable.USERID = messageTable.USERID i am using the following query but it is not working as expcted

 SELECT 
m.ID as CHATID, p.USERID, p.NAME, p.IMAGEURL, p.LASTACTIVE, p.logedinuserid, p.status, m.MESSAGEBODY, m.CREATEDTIME 
from chatPersonTable as p join messageTable as m

 on p.USERID = m.USERID 
 where p.LOGEDINUSERID = "119" 
 group by m.USERID order by m.CREATEDTIME desc