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 = 'UZAA' Discount Advantus Tags & Tickets | Save with Wholesale Discount pricing at
FREE Shipping on $1000+ Orders
Free Shipping on all orders over $1000
$10 Off $100

Advantus Tags & Tickets

Results: 15 | 45 | 90
Sort By:
AVT2612TW Image
Best Seller!
Advantus 12" Long Tag Wires
1000 Wires Per Pack, AVT2612TW
AVT2675TW Image
Advantus 7-1/2" Long Tag Wires
1000 Wires Per Pack, AVT2675TW
Results: 1 - 2 of 2
Narrow Results
Tags & Tickets
Advantus X
By Price