文件名称：sql王珊习题程序解析
文件大小：4KB
文件格式：TXT
更新时间：2014-04-26 14:48:16
sql
4.1.SELECT SNO FROM SPJ WHERE JNO='J1' 4.2.SELECT SNO FROM SPJ WHERE JNO='J1' AND PNO='P1' 4.3.SELECT SNO FROM SPJ,P WHERE SPJ.PNO=P.PNO AND COLOR='红' AND JNO='J1' OR:SELECT SNO FROM SPJ WHERE JNO='J1' AND PNO IN (SELECT PNO FROM P WHERE COLOR='红')