Ex.
select la.code, la.title, c.systemid, c.FIRSTNAME||' '||c.LASTNAME student_name, a.DATETIMEENROLLED
,a.DATETIMECOMPLETED, start_date, c.SITE
from drlearningactivitytranscript a, drlearningactivity la, druser c
,(
select start_date
,lat_id
from (
select drli.FIRSTMEETINGSTART start_date
,lat.ID lat_id
from drlearningactivity la
,drlearningactivitytranscript lat
,drlearningactivityinstance drli
where la.id=lat.learningactivityid
and drli.ID=lat.LEARNINGACTIVITYINSTANCEID
and drli.LEARNINGACTIVITYID=la.ID) )
where a.id=lat_id(+)
and a.userid = c.userid
and la.id = a.learningactivityid
order by a.datetimecompleted
Any input is greatly appreciated.
2007-03-26
10:04:18
·
2 answers
·
asked by
rio27713
2