【问】尺码没有尺码名称问题 | ||
【适用版本】服装之星9 | 【模块】基础业务 | 【点击数】74 |
【知识编号】Z2015080400020 | ||
【问题描述】尺码没有尺码名称问题 |
use hbfsv9
go
INSERT INTO t_bd_base_code
select a.*,’1′ as code_order,’SI’ as size_group_id
from (select type_no,code_id,code_name,english_name,code_type,memo from t_bd_base_code where type_no=’SI’ GROUP BY
type_no,code_id,code_name,english_name,code_type,memo) a
where a.code_id not in (SELECT code_id from t_bd_base_code where type_no=’SI’AND SIZE_GROUP_ID=’SI’)