Rings - One of a Kind

Sub Category

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

Stone Type

Amethyst
AQUAMARINE
Blue Sapphire
Blue Topaz
Citrine
Diamond
Emerald
Emerald, Sapphire, Ruby
Emerald` Diamond
Garnet
London Blue Topaz
Multi
Multi Sapphire
Pink Sapphire
Ruby
Ruby+Emerald
Ruby` Diamond
Sapphire
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