有两张表
表1:
姓名       年龄        性别
a           20          男 
b           18          男表2:
姓名      日期              成绩
a         2006-08-01         98
a         2006-07-31         75   
b         2005-07-25         85
a         2004-05-06         63
b         2003-05-05         52我想出以下这样的报表:
-----------------------------
 姓名       年龄        性别
-----------------------------
 a           20          男 
-----------------------------
 日期          成绩
-----------------------------
 2006-08-01     98
 2006-07-31     75 
 2004-05-06     63
----------------------------------------------------------
 姓名       年龄        性别
-----------------------------
 b           18          男 
-----------------------------
 日期          成绩
-----------------------------
 2005-07-25     85
 2003-05-05     52
-----------------------------