Thanks to everyone that replied with the suggestions and ideas.
Here is what I ended up with, I added the requirement for also reporting
the user name of the person that created the last iteration.
select a.documentnumber as NUM, b.versionida2versioninfo
as REV, b.iterationida2iterationinfo as ITER, b.statestate as STATE,
b.classnamea2a2 as TYP, c.name as USR
from epmdocumentmaster a, epmdocument b, wtuser c
where b.statestate='RELEASED' and
b.ida3masterreference=a.ida2a2 and b.ida3d2iterationinfo=c.ida2a2;
Thanks again for all the great help!!!
Greg
