SELECT LTRIM(RTRIM(C.ClassName)) as ClassName, LTRIM(RTRIM(C.Clabelid)) as ClabelID, LTRIM(RTRIM(D.DepartmentName)) as DepartmentName, LTRIM(RTRIM(D.DepartmentLabel)) as DepartmentLabel, LTRIM(RTRIM(T.dlabelid)) as dlabelID FROM dbo.Class3qtr C LEFT JOIN dbo.Department3qtr D ON D.DEPARTMENTLABEL = LEFT(C.ClassLabel, 1) LEFT JOIN dbo.tbl_dlabelid T ON T.DepartmentLabel=D.DepartmentLabel WHERE C.ClassLabel = 'KDFA' Discount Vacuums | Save with Wholesale Discount pricing at
FREE Shipping on $1000+ Orders
Free Shipping on all orders over $1000
$10 Off $100


Results: 15 | 45 | 90
Sort By:
RCP9VDVSS4400 Image
Free Shipping!
HVRCH50102 Image
Hoover Insight Bagged Upright
15" Cleaning Path, 10 A, 20 lb., Black, HVRCH50102
MFMWVP20 Image
Mercury Floor Machines Storm Wet-Dry Tank Vacuum
Dual Motor, 20 Gallon Poly Tank, Gray, MFMWVP20
SHO1034200 Image
Shop-Air Wall Mount Blower
16", Stainless Steel, 3-Speed, 1/2 HP Motor, SHO1034200
Results: 1 - 4 of 4
Narrow Results
By Price
$403.00 - $804.00 X