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