Gift Vouchers

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','Gift Vouchers','') and EdgeMaster.MCategory='Gift Vouchers' order by (EdgeMaster.SCategory) asc