求救！会SQL的请进来，一行转列语句

[dbkite]

string xuehao = listView1.Items[listView1.FocusedItem.Index].Tag.ToString().Trim();
string xq = comboBox3.Text.Trim();
//行转列
string sql = "select a.score as Java程序设计,b.score as 大学英语,c.score as 高级代数,d.score as Access数据库,(a.score + b.score + c.score +d.score) as total from((scoreinfo as a inner join scoreinfo as b on a.ScoreID=b.ScoreID) inner join scoreinfo as c on a.ScoreID=c.ScoreID) inner join scoreinfo as d on a.ScoreID=d.ScoreID where studentnumber=" + xuehao + " and semester=" + xq + " ";

OleDbDataAdapter adp = new OleDbDataAdapter(sql, connection1);
ds = new DataSet();
adp.Fill(ds,"score"); //出错的位置
//该特定字段'studentnumber'可以参考SQL语句中FROM子句列表中的多个表。

请高手帮我看看是哪里出错

[Garnett_KG]

string sql = "select 	a.score as Java程序设计,
	b.score as 大学英语,
	c.score as 高级代数,
	d.score as Access数据库,
	(a.score + b.score + c.score +d.score) as  total 
from	(
		(
		scoreinfo as a inner join scoreinfo as b 
		on a.ScoreID=b.ScoreID
		) 
		inner join scoreinfo as c 
		on a.ScoreID=c.ScoreID
	) 
	inner join scoreinfo as d 
	on a.ScoreID=d.ScoreID 
where   a.studentnumber=" + xuehao + " and a.semester=" + xq + " ";

[datafansbj]

行转列的简单方法应该使用Case语句(SQL Server)

[amandag]

估计你的多个表有studentnumber字段，明确地写a.studentnumber或者b.studentnumber..

[wuyq11]

确定studentnumber属于哪个表

[清风net]

不会``学习

[a13vf2]

不会哦，不过学习学习下也好呀

[myrroom]

也来学习