Rings

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='Rings' order by (SSCategory) asc

Stone Type

Amethyst
Aquamarine
Blue Topaz
Citrine
DIAMOND
DIAMOND` AMETHYST
DIAMOND` BLUE SAPPHIRE` SAPPHIRE
DIAMOND` EMERALD
DIAMOND` GREEN TOURMALINE` TOURMALINE
DIAMOND` RUBY
DIAMOND` SAPPHIRE` BLUE SAPPHIRE
DIAMOND` SAPPHIRE` PINK SAPPHIRE
DIAMOND` SKY BLUE TOPAZ` BLUE TOPAZ` TOPAZ
DIAMOND` WATERMELON TOURMALINE` TOURMALINE
Emerald
Emerald, Sapphire, Ruby
Emerald` Diamond
Garnet
London Blue Topaz
Multi
Multi Sapphire
Pink Sapphire
Ruby
Ruby+Emerald
Ruby` Diamond
Sapphire
SAPPHIRE` BLUE SAPPHIRE` DIAMOND
Sapphire` Diamond
Spinel
Tourmaline
White Topaz

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='Rings' order by (AddInfo4) asc