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