>>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.Pk>
>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 >Hi,