oracle 三个表放到一起,在oracle 10g中加入三个表

我有3张桌子，大学，学生和结果

create table college

(

clg_id int,

clg_name varchar2()50,

insert into college values(1,'GIFT');

insert into college values(2,'GITA');

insert into college values(3,'MIT');

create table student

(

clg_id int,

regno int,

sname varchar2(50)

)

insert into student values(1,10,sahar);

insert into student values(2,11,raj);

insert into student values(3,12,Payal);

insert into student values(3,13,Monalisha);

insert into student values(2,14,mary);

create table Result

(

clg_id int,

sname varchar2(50),

clg_name varchar2(50),

regno int,

dt date,

result varchar2(30)

)

insert into Result values(1,'sahar',10,'GIFT',20-02-1990,'A+');

insert into Result values(2,'raj',11,'GITA',21-02-1991,''B+);

insert into Result values(3,'monalisha',13,'MIT',22-09-2005,'A++');

insert into Result values(3,'payal',14,'MIT',22-09-2005,'C');我想从浏览器中提供一个特定的dt和clg_id，并显示result，学生姓名，学院名称和regno，结果在哪个日期存储。

例如：我将输入clg_id = 3和dt = 22-09-2005，然后显示：

clg_name sname regno result

MIT monalisha 13 A++

MIT payal 14 C我尝试了很多...我的一个尝试是

SELECT college.clg_name,student.sname,

student.regno result.result FROM college,student,result

WHERE college.clg_id=student.clg_id=result.date;但这是错误的...请帮助。