>what is mistake in this sql
>
>

>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,sec

Your 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,sec

Also these fields with CAST look a bit suspicious to me.