>SELECT Student.*, Examtran.*; > FROM ; > student ; > RIGHT JOIN examtran ; > ON Student.code = Examtran.code,; > (Cast(Sum(obt01) As I)) /Count(code) As CW,; > (Cast(Sum(obt02) As I)) /Count(code) As HW,; > (Cast(Sum(obt03) As I)) /Count(code) As Calli,; > (Cast(Sum(obt04) As I)) /Count(code) As Clean,; > (Cast(Sum(obt05) As I)) /Count(code) As Presence; > WHERE year=2006 AND bex=2.and.Student.admtd = 1; > GROUP By lcode,Sec,code; > order By lcode,secYour fields list should preceed FROM and JOIN clauses, e.g.
SELECT Student.*, Examtran.*, ; (Cast(Sum(obt01) As I)) /Count(code) As CW,; (Cast(Sum(obt02) As I)) /Count(code) As HW,; (Cast(Sum(obt03) As I)) /Count(code) As Calli,; (Cast(Sum(obt04) As I)) /Count(code) As Clean,; (Cast(Sum(obt05) As I)) /Count(code) As Presence ; FROM ; student ; RIGHT JOIN examtran ; ON Student.code = Examtran.code ; WHERE year=2006 AND bex=2.and.Student.admtd = 1; GROUP By lcode,Sec,code; order By lcode,secAlso these fields with CAST look a bit suspicious to me.