1.select s.sname from s,p,sp where s.sno = sp.sno and sp.pno = p.pno and p.pname like '%紅色零件%'2.select sno, sname, status from s where city='北京'3.select sum(sp.qty) from sp, p where sp.pno = p.pno and p.pname like '%P2%'4.select sum(p.VEIGHT) from sp, p where sp.pno = p.pno and p.pname like '%P2%'5.update p set color = '黃色'
上一篇:家用電葫蘆升降機加防墜器可以載人嗎下一篇:求助易語言post怎麽實現拖動完成拼圖