“找出北京供应商供应的所有零件信息”的SELECT语句是（ ）。 A．SEL

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

• ASELECT*FROM S WHERE CITY=’北京’
• BSTLECT SNO,SNAME FROM S WHERE CITY=’北京’
• CSELECT P.*FROM S,P WHERE S.CITY=’北京’ AND S.SNO=SJP.SNO AND SJP.PNO=P.PNO
• DSELECT P.*FROM P,S,SJP WHERE S.CITY=’北京’ AND S.SNO=SJP.SNO AND SJP.PNO=P.PNO