有关系表SC ( S# , C#, Score)，求既学过“001”号课又学过 “002”号课的所有学生的学号，下列SQL语句正确的是（ ）

题目：有关系表SC ( S# , C#, Score)，求既学过“001”号课又学过 “002”号课的所有学生的学号，下列SQL语句正确的是（ ）

A. Select S1.S# From SC as S1 Where S1.C# = '001' AND S1.C#='002';

B. Select S1.S# From SC as S1, SC as S2 Where S1.S# = S2.S# and S1.C#='001' and S2.C#='002' ;

C. Select S# From SC Where C# = '001' AND C#='002';

D. Select S2.S# From SC as S1, SC as S2 Where S1.S# = S2.S# or S1.C#='001' and S2.C#='002';

答案：评论后可见此内容