UNPIVOT 可能会有所帮助...
SELECT p.customerCode, REPLACE(p.groupcode,'GROUP','') groupcode, ocqg.groupname
FROM ocrd UNPIVOT
( value
FOR groupcode IN ([Group1],[Group2],[Group3], etc...)
) as p,
ocqg
WHERE value = 'Y' and
ocqg.groupcode = REPLACE(p.groupcode,'GROUP','')
order by p.customerCode
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句