pro_cata_sup.sql

来自「本程序是将ORACLE数据库中的表导出成为XML文件的程序。 1. 运行本程序」· SQL 代码 · 共 14 行

select a.supplier_id,a.catagory_id,a.pcnt,
c.company_name_en,c.service_level,c.gmc_flag, b.id1,b.id2,b.id3,b.id4
from 
(select supplier_id,catagory_id,count(product_id) pcnt 
 from product 
 where status='S'
 group by supplier_id,catagory_id) a,
suppliers c,
catagory4 b
where 
a.supplier_id=c.supplier_id
and b.id4=a.catagory_id
and c.on_level='B'
order by service_level