hello.. just wanna ask some help.. i have a tables such as prospectus, tempevaluation, subject. in prospectus theres a field such as (subcode, prosno,yrlevel,term) in tempevaluation(subcode,grade,prosno) in subject (subcode,units,description) first, I would like to query all subcode,grade,units,description from tempevaluation, subject $query="select s.subcode,s.description,s.units,t.grade from tempevaluation t, subject s where t.prosno='121' and s.subcode=t.subcode and t.yrlevel='I' and t.term='1st' "; the result will display the subcode, description, units and grade.. now, if in the table tempevaluation has only subjects from yearlevel (ist) and term=(1st) and I would like to display the other subject to from prospectus from 1st year to 4th year without grade coz the grades only found in the tempevaluation.. How do i make the query.. that would display as the format of prospectus ex.. first Year 1st semester 1.00 math 112 algebra 2.00 engl 111 english commu first year 2nd semester _____ IT 11 Intro to IT _____ IT 12 programing Second year til 4yr anyone could help.. thanks..
