have a try select a.title, b.version, b.amenddate from article a, (select max(version), articleid, amenddate from version group by articleid, amenddate) b where a.articleid = b.articleid
select v.articleid ,a.title,v.amenddate from version v join (select articleid ,max(version) version from version group by articleid) t on (t.articleid = v.articleid and v.version = t.version) left join article a on (a.articleid = t.articleid);
select a.articleid ,a.title,t.version,t.amenddate from article a join (select articleid ,max(version) version,amenddate from version group by articleid) t on (t.articleid = a.articleid )
select a.articleid,b.version,b.amenddate from version b where version=(select max(version) from version group by articleid, amenddate) left jion article a on(a.articleid = t.articleid)
select a.title, b.version, b.amenddate
from article a,
(select max(version), articleid, amenddate from version
group by articleid, amenddate) b
where a.articleid = b.articleid
select
v.articleid ,a.title,v.amenddate
from
version v
join
(select articleid ,max(version) version from version group by articleid) t
on
(t.articleid = v.articleid and v.version = t.version)
left join
article a
on
(a.articleid = t.articleid);
select
a.articleid ,a.title,t.version,t.amenddate
from
article a
join
(select articleid ,max(version) version,amenddate from version group by articleid) t
on
(t.articleid = a.articleid )