有关系表SC ( S# , C#, Score)，求既学过“001”号课又学过 “002”号课的所有学生的学号，下列SQL语句正确的是_________。
A、Select S# From SC Where C# = ‘001’ AND C#=‘002’;
B、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and  S2.C#=‘002 ;
C、Select S2.S# From SC S1, SC S2 Where S1.S# = S2.S# or S1.C#=‘001’ and  S2.C#=‘002 ;
D、Select S1.S# From SC S1 Where S1. C# = ‘001’ AND S1.C#=‘002’;