查询学生姓名、所属年级及电话

-- 查询学生姓名、所属年级及电话
select *from Student
select *from dbo.Grade
--where
select  s.StudentName 姓名, g.GradeName 年级名称, s.Phone   from Student s, Grade g
where s.GradeId=g.GradeId
--inner join ..on
select  s.StudentName 姓名, g.GradeName 年级名称, s.Phone   from Student s
inner join Grade g on s.GradeId=g.GradeId


--查询年级编号为1的年级名称、科目信息及学时
select *from dbo.Grade
select *from dbo.Subject
--where
select     from Subject s, Grade g
where s.GradeId=g.GradeId