Necklaces - One of a Kind

Select distinct SSCategory from CJlryMaster where AddInfo20<>'y' and PQty<>0 and SSCategory not in ('','Null','0') and CJlryNote not in ('Null') and MCategory='Jewelry' and SCategory='Necklaces' order by (SSCategory) asc

Stone Type

Alexandrite
Amethyst
Blue Topaz
DIAMOND
DIAMOND` AQUA` AQUAMARINE
DIAMOND` EMERALD
DIAMOND` GREEN TOURMALINE` TOURMALINE
DIAMOND` RUBELLITE
Emerald
Emerald` Diamond
Garnet
Green Quartz
LONDON BLUE TOPAZ` DIAMOND
Multi
Pink Tourmaline
Rhodolite` Diamond
Ruby
Ruby` Diamond
Sapphire
Sapphire` Diamond
Smokey Quartz
Tourmaline

Select distinct AddInfo4 from CJlryMaster where AddInfo20<>'y' and PQty<>0 and AddInfo4 not in ('','Null','0') and CJlryNote not in ('Null') and MCategory='Jewelry' and SCategory='Necklaces' order by (AddInfo4) asc