Misc

Select distinct(EdgeDetailsMaster.StoneType) FROM EdgeMaster JOIN EdgeDetailsMaster ON (EdgeMaster.categoryType = EdgeDetailsMaster.EdgeCategoryType and EdgeMaster.StockNum = EdgeDetailsMaster.EdgeStockNum and EdgeMaster.SKU = EdgeDetailsMaster.EdgeSKU) where EdgeDetailsMaster.MCategory = EdgeMaster.MCategory and EdgeMaster.TotalAvailQOH>0 and EdgeDetailsMaster.StoneType not in ('Null','','N/A','Misc','') and EdgeMaster.MCategory='Misc' order by (EdgeDetailsMaster.StoneType) asc