pro_cata_supnofree.sql

本程序是将ORACLE数据库中的表导出成为XML文件的程序。 1. 运行本程序前必须确保机器上已安装JDK 1.4.x 2. 编辑cfg.ini中的参数 3. 运行startup.bat

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'
and c.service_level<>'X'
order by service_level