The table is called TransitionHistory. It contains the DocumentID, TransitionID, and Date you can build the SQL query from. You'll have to get the TransitionID(s) from the "Transtions" table to filter it down.
Here's a smaple query......looks for a transition named "Reject" in which we have several rejection transitions from various states. If you want a particular one, you'll have to track down its ID.
SELECT d.filename as 'File Name', th.date as 'Date Transtioned', TH.TransitionID, T.Name as 'Transition Name', TH.Comment, Usr.FullName as 'Transitioned by'
FROM TransitionHistory TH
inner join Transitions T on TH.TransitionID=T.TransitionID
inner join Documents D on D.DocumentID=TH.DocumentID
inner join Users Usr on Usr.UserID=TH.UserID
where t.name like 'reject'
order by Date desc
Thanks, Jason, I got what I needed. I need to brush up on writing queries against SQL. I've done a ton of stuff using Access. Going to have our SQL guy show me a few tips to bring me up to speed.