前面"疯癫籹孒's " 回答的不对哦.应该这样:
use 数据库名称
select xingmingbiao.name as 姓名,kechengbiao.name as 课程,
chengjibiao.chengji as 成绩 from chengjibiao
INNER JOIN xingmingbiao in chengjibiao.xingming_id=xingmingbiao.id
Inner join kechengbiao in chengjibiao.kecheng_id=kechengbiao.id
where chengjibiao.chengji >=90
go
你在查询分析器里运行就可以得到结果了.