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