Re: MAX() with Joins and Subqueries

Your base query is something like the following.

select *
from tbl_doc_ver tdv1
where doc_ver_num = (
select max(doc_ver_num)
from tbl_doc_ver tdv2
where tdv2.doc_id = tdv1.doc_id
and tdv2.domain_id = tdv1.domain_id)

From there you would add the additional columns by adding joins to the outer select.

--
Later,
BEDick