if you need just MIN and MAX value of
pps_transcript_details.date_created for each distinct course,
you can do
something like:
SELECT ps.name as ModuleName, MIN(ptd.date_created) as
MinDateCreated,
MAX(ptd.date_created) as MaxDateCreated
FROM pps_principals pp, pps_scos ps, pps_transcripts pt,
pps_transcript_details ptd
WHERE 1=1
AND pp.principal_id = pt.principal_id
AND pt.sco_id = ps.sco_id
AND pt.transcript_id = ptd.transcript_id
AND pp.name = 'Lee Duncan'
AND pt.status = 'F'
AND ps.name like 'MTM-%'
AND pt.ticket not like 'l-%'
GROUP BY ps.name
NOTE: the above is untested, but should work... :)
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/