表的外键连接语句怎么写？

[LOVEYOUMacBook]

从外键字段查询出主表的信息

表的结构是怎么设置的？例如：Student表 Class表


查询语句怎么编写？

谢谢了兄弟！！姐妹~~~

[dr_lou]

create table student(
  id int primary key,
  name varchar2(10),
  classId int 
);

create table class1(
  id int primary key,
  name varchar2(10)
);

alter table student
   add constraint FK_student_REFERENCE_classid foreign key (classId)
      references class1(id);
      
insert into class1 values(1,'一班');
insert into class1 values(2,'二班');

insert into student values(1,'张三',1);
insert into student values(2,'李四',1);
insert into student values(3,'王五',1);
insert into student values(4,'赵六',2);
insert into student values(5,'钱七',2);

select * from class1 where id = (
  select classid from student where name = '赵六'
);

是这个意思么？