[Code]...

left join transcriptgpa as t on

p.people_code_id=t.people_code_id

and t.record_type='O'

and t.academic_term='Fall'

and t.academic_year='2007'

where a.academic_term='Spring'

and a.academic_year='2008'

and a.enroll_separation ='enrl'

and a.academic_session='main'

and (a.program ='ft' or a.program='pt')

[/Code]