>select * from Table1 inner join Table2 on Table1.Pk = Table2.fk ; >inner join (select Pk, Min(date) as MinDate from Table2 group by 1) ; >MinDate on Table2.Pk = MinDate.PkThanks, with your help I came up with the following solution which works for me:
SELECT title, body,abstract,blog_config.author,tblMaxEntries.*,; ALLTRIM(SUBSTR(basepath,AT("/",basepath)+1)) as gebruiker; from blog_entries; inner join; (select blogpk,Max(entered) as entered FROM blog_entries GROUP BY blogpk) tblMaxEntries; ON tblMaxentries.blogPK = blog_entries.blogpk AND blog_entries.entered = tblMaxentries.Entered; right OUTER JOIN blog_config; on blog_config.pk = blog_entries.blogpk