阅读背景:

如何使用内部联接将数字1,2,3设置为子表数据

来源:互联网 

My query look like this

我的查询看起来像这样

        select 
        SKU+'_'+'Attribute' as AttributeName,
        SKU as AttributeCode,
        SKU as AttributeKeyName,
        'Select Colors' as AttributeDisplayName,
        sc.PRIMARYOMSCODE as  AttributeValueName,
        cl.PMSCOLOR as AttributeValueCode,
        cl.RGBCOLOR as AttributeValueKeyValue,
        scl.NAME as AttributeValueDisplayName,
        '' as AttributeValueDisplayOrder,



        SKU+'_'+sc.PRIMARYOMSCODE+'.png' as AttributeValueImageName,
        'All' as AttributeValueCategory,
        'FALSE' as IsHideInpreview

         from con.style s 
        inner join con.styleColor sc on s.STYLEID = sc.STYLEID
        inner join con.color cl on sc.PRIMARYCOLORID = cl.COLORID
        inner join con.styleColorLanguage scl on scl.STYLECOLORID = sc.STYLECOLORID
        where s.SKU in ('805B3','804DK','802ZW') and sc.DELETEIND= 0 
       



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: