两个主键两个外键要怎么写语句呢

你要写什么语句，都一样的，你是创建表不懂还是查询。

create table T_student_info(
student_no char(6) not null PRIMARY key,
student_name VARCHAR(20) not null,
sex char(2) not null,
birth datetime not null,
enter_date int(11) not null,
address varchar(50) not null
)

create table T_course_info(
course_no char(8) not null PRIMARY key,
course_name varchar(50) null,
credit int(11) null,
classhour int(11) null
)

create table t_student_scores(
student_no char(6) not null,
scores_no char(8) not null,
PRIMARY key(student_no,total_scores),
ordinary_scores float not null,
end_scores float not null,
total_scores float not null,
CONSTRAINT fk_student_scores_course_info FOREIGN KEY (scores_no) REFERENCES T_course_info(scores_no ),
CONSTRAINT fk_student_scores_student_info FOREIGN KEY (student_no) REFERENCES T_student_info(student_no) 
)

1005 - Can't create table 'student09dq.t_student_scores' (errno: 150)

出现150错误，是哪里错了呀