dev7 - 12:16 pm on Apr 29, 2013 (gmt 0)
@nettulf: Thank you so much for the break through. This approach seems promising but i have never used subqueries before. so let me try to work, and one more thing - my database is having many to many relationships and using INNER JOIN (for single table). now am confused!
let me give you the code:
from class file:
SELECT m.msg_id,m.acc_id,b.msg_id .........
FROM eb_msg m
INNER JOIN eb_msg_body b on m.msg_id = b.msg_id
WHERE m.acc_id = 123 ORDER BY m.date DESC 10
@topr8: thanks for participating :-)