“找出北京供应商供应的所有零件信息”的SELECT语句是( )。
A．SELECT*FROM S WHERE CITY=’北京’
B．SELECT SNO，SNAME FROM S WHERE CITY=’北京’
C．SELECT
P．*FROM S,P WHERE
S．CITY=’北京’ AND
S．SNO=SJ
P．SNO AND SJ
P．PNO=
P．PNO
D．SELECT
P．*FROM P,S,SJP WHERE
S．CITY=’北京’ AND
S．SNO=SJ
P．SNO AND SJP.PNO=EPNO