Re: [web2py] Re: Inner join on subselect

[Vasile Ermicioi]

what database do you use?
I tested with sqlite on a table of mine and it works

SELECT id, category,  max(added_on) , title FROM articles GROUP BY category
HAVING added_on=max(added_on)

that query shows latest article from each category