VF Grid 控件怎样添加两个表的数据

a,b两表
select a.a as 姓名,a.b as 性别,a.c as 班级 b.a as 语文成绩 from a right join b on a.学号=b.学号 into cursor aa
select aa
thisform.grid1.recordsource="aa"

RecordSourceType 4-sql查询。RecordSource中编写语句或在其它地方指定sql语句