实现“查询与同系的学生信息(基于自身连接)”的SELECT语句为()
A.
SELECT S2.* FROM Student S1,Student S2 WHERE S1.Sname=' '
B.
SELECT S2.* FROM Student S1 JOIN Student S2 ON S1.Sdept=S2.Sdept AND S1.Sname=' '
C.
SELECT S2.* FROM Student S1 JOIN Student S2 ON S1.Sdept=S2.Sdept OR S1.Sname=' '
D.
SELECT S2.* FROM Student S1,Student S2 WHERE S1.Sdept=S2.Sdept AND S1.Sname=' '