sql语句:
select distinct s.sname from s, p, spj
where p.pname = '螺母'
and p.pno = spj.pno
and spj.jno = 'j1'
and spj.qty = '没有供应'
and spj.sno = s.sno
order by s.sname
select distinct s.sname from s, p, spj
where p.pname = '螺母'
and p.pno = spj.pno
and spj.jno = 'j1'
and spj.qty = '没有供应'
and spj.sno = s.sno
order by s.sname
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货