create table tblType(
ID INT IDENTITY(1,1),
SUBID INT,
TYPEID INT,
NAME VARCHAR(50)
)
GOINSERT INTO tblType(SUBID,TYPEID,NAME)
SELECT -1,1,'农林牧渔产品及生产资料' UNION ALL
SELECT 1,2,'农业生产资料' UNION ALL
SELECT 2,3,'除草剂、杀虫剂' UNION ALL
SELECT 2,4,'化肥' UNION ALL
SELECT 2, 5 ,'农药' UNION ALL
SELECT 2, 6 ,'饲料' UNION ALL
SELECT 2, 7 ,'种子' UNION ALL
SELECT 2, 8 ,'农资杂项' UNION ALL
SELECT 2, 9 ,'农资企业形象'UNION ALL
SELECT 1 ,10 ,'农林牧渔产品'UNION ALL
SELECT 10,11 ,'粮食' UNION ALL
SELECT 11,12 ,'大麦' UNION ALL
SELECT 11,13 ,'豆类' UNION ALL
SELECT 11,14 ,'高粱' UNION ALL
SELECT 11,15 ,'荞麦' UNION ALL
SELECT 11,16 ,'黍' UNION ALL
SELECT 11,17 ,'薯类' UNION ALL
SELECT 11,18 ,'水稻' UNION ALL
SELECT 11,19 ,'小麦' UNION ALL
SELECT 11,20 ,'燕麦' UNION ALL
SELECT 11,21 ,'玉米' UNION ALL
SELECT 11,22 ,'其它' UNION ALL
SELECT 10,23 ,'油料作物' UNION ALL
SELECT 23,24 ,'蓖麻' UNION ALL
SELECT 23,25 ,'菜花籽' UNION ALL
SELECT 23,26 ,'大豆' UNION ALL
SELECT 23,27 ,'橄榄'GOSELECT c.TYPEID,C.NAME 产品大类名称,B.NAME 产品中类名称,a.NAME 产品小类名称
FROM tblType A inner join tblType b on a.subid=b.id inner join tblType c on b.subid=c.id
ID INT IDENTITY(1,1),
SUBID INT,
TYPEID INT,
NAME VARCHAR(50)
)
GOINSERT INTO tblType(SUBID,TYPEID,NAME)
SELECT -1,1,'农林牧渔产品及生产资料' UNION ALL
SELECT 1,2,'农业生产资料' UNION ALL
SELECT 2,3,'除草剂、杀虫剂' UNION ALL
SELECT 2,4,'化肥' UNION ALL
SELECT 2, 5 ,'农药' UNION ALL
SELECT 2, 6 ,'饲料' UNION ALL
SELECT 2, 7 ,'种子' UNION ALL
SELECT 2, 8 ,'农资杂项' UNION ALL
SELECT 2, 9 ,'农资企业形象'UNION ALL
SELECT 1 ,10 ,'农林牧渔产品'UNION ALL
SELECT 10,11 ,'粮食' UNION ALL
SELECT 11,12 ,'大麦' UNION ALL
SELECT 11,13 ,'豆类' UNION ALL
SELECT 11,14 ,'高粱' UNION ALL
SELECT 11,15 ,'荞麦' UNION ALL
SELECT 11,16 ,'黍' UNION ALL
SELECT 11,17 ,'薯类' UNION ALL
SELECT 11,18 ,'水稻' UNION ALL
SELECT 11,19 ,'小麦' UNION ALL
SELECT 11,20 ,'燕麦' UNION ALL
SELECT 11,21 ,'玉米' UNION ALL
SELECT 11,22 ,'其它' UNION ALL
SELECT 10,23 ,'油料作物' UNION ALL
SELECT 23,24 ,'蓖麻' UNION ALL
SELECT 23,25 ,'菜花籽' UNION ALL
SELECT 23,26 ,'大豆' UNION ALL
SELECT 23,27 ,'橄榄'GOSELECT c.TYPEID,C.NAME 产品大类名称,B.NAME 产品中类名称,a.NAME 产品小类名称
FROM tblType A inner join tblType b on a.subid=b.id inner join tblType c on b.subid=c.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货