select c.ordernum,a.partnum,max(a.quantityordered) from quantity a,part b,orders c where a.partnum=b.partnum(+) and a.ordernum(+)=c.ordernum and a.ordernum in (21617,21610,21699) and b.PartDescription in ('Dishwasher','Microwave Oven') group by c.ordernum,a.partnum
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货