百胜 bs3000+ 更改款式 尺码的SQL语句

 select  TOP 100 PERCENT SPGG1.SPDM as SPDM, SPGG1.GGDM as GGDM, GUIGE1.GGDM as  GGDM_SUB, GUIGE1.GGMC as  GGMC_SUB, SPGG1.BYZD1 as BYZD1 from SPGG1 as SPGG1, GUIGE1 as GUIGE1 where SPGG1.GGDM =  GUIGE1.GGDM and SPDM = 'Q122410238A'
go

 select  TOP 100 PERCENT SPGG2.SPDM as SPDM, SPGG2.GGDM as GGDM, GUIGE2.GGDM as  GGDM_SUB, GUIGE2.GGMC as  GGMC_SUB from SPGG2 as SPGG2, GUIGE2 as GUIGE2 where SPGG2.GGDM =  GUIGE2.GGDM and SPDM = 'Q122410238A'

--尺码规则 GUIGE2.GGDM 尺码代码，GUIGE2.GGMC 尺码名称
SELECT * FROM GUIGE2
--颜色规则
SELECT * FROM GUIGE1
SELECT * FROM SPGG2

select Name from sysobjects where xtype='u' and status>=0 order by name

 

go
 select  TOP 100 PERCENT ShangPinTM.SPDM as SPDM, ShangPinTM.bPrint as bPrint, ShangPinTM.TMID as TMID, vw_TM.TMID as  TMID_SUB, vw_TM.BYZD1 as  BYZD1_SUB from ShangPinTM as ShangPinTM, vw_TM as vw_TM where ShangPinTM.TMID =  vw_TM.TMID and SPDM = 'Q122410238A'
go
--商品的的打印规则的设置 ShangPinTM.TMID  是规则设置
SELECT * FROM ShangPinTM
--编码规则
SELECT * FROM vw_TM

 select  TOP 100 PERCENT ShangKeHu.SPDM as SPDM, ShangKeHu.KHDM as KHDM, KEHU.KHDM as  KHDM_SUB, KEHU.KHMC as  KHMC_SUB from ShangKeHu as ShangKeHu, KEHU as KEHU where ShangKeHu.KHDM =  KEHU.KHDM and SPDM = 'Q122410238A'
go
 select  TOP 100 PERCENT ShangCheckGoal.SPDM as SPDM, Shang