Men's Collection

Select distinct(EdgeMaster.SCategory) 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 EdgeMaster.SCategory not in ('Null','','N/A','Men','') and EdgeMaster.MCategory='Men' order by (EdgeMaster.SCategory) asc

Select distinct(EdgeDetailsMaster.MetalType) 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.MetalType not in ('Null','','N/A','Men','') and EdgeMaster.MCategory='Men' order by (EdgeDetailsMaster.MetalType) asc