您所在位置：主题：我是新手，刚刚开始学SQL，想问一个问题
askdo
[专家分：20] 发布于 2005-07-30 11:47:00
[size=3]我这有一例
select student.Sno,Sname,Ssex,Sdept,Sno,Grade
From student,SC
where student.Sno=SC.Sno(*)
上面一例和下面一例
select student.Sno.Sname,Ssex,Sdept,Sno,Grade
From student,SC
where student.Sno(*)=sc.Sno
查询结果一样吗？
[/size][em17]
select student.Sno,Sname,Ssex,Sdept,Sno,Grade
From student,SC
where student.Sno=SC.Sno(*)
上面一例和下面一例
select student.Sno.Sname,Ssex,Sdept,Sno,Grade
From student,SC
where student.Sno(*)=sc.Sno
查询结果一样吗？
[/size][em17]
