SQL Query to get First post of users

[induslady]

Hello,

Am using the below query to get the post of the users registered during Jan 2015:


SELECT a.title, a.username, a.postid FROM post a, user b
WHERE a.userid = b.userid
AND FROM_UNIXTIME (b.joindate) BETWEEN '2015-01-01' AND '2015-02-01'


From the above query result I would like to get ONLY the first post of each of these users. How do I write the query? Thanks in advance.

[kh99]

Maybe try adding:
ORDER BY b.joindate LIMIT 1

Edit: oh, wait, that's wrong. It would only work if you were selecting the posts from one user. Now I see why you're asking. :)

[Replicant]

Try appending GROUP BY a.userid
to the end of the query.