SELECT Series.Series, Series.Short_Desc As Series_Desc, Types.Description As Type_Desc
FROM Series
INNER JOIN Types
ON Series.Type=Types.Type
ORDER BY Types.Description, Series.Short_Desc
Particle Size:
SELECT DISTINCT Size FROM Products
WHERE Size <> 'In-Line Column Prefilters, pkg of 10' AND Size <> 'Kit. Contains 1 each: 201SP54, 218WP54, & 238WP54'
ORDER BY Size
Product Type:
SELECT DISTINCT Size_Type FROM Products ORDER BY Size_Type
Inner Diameter:
SELECT DISTINCT Inner_Diameter FROM Products
WHERE Inner_Diameter <> '1 mL' AND Inner_Diameter <> '3 mL' AND Inner_Diameter <> 'Kilogram +' AND Inner_Diameter <> '100 grams' AND Inner_Diameter <> '500 grams'
ORDER BY Inner_Diameter
Length:
SELECT DISTINCT Length FROM Products
WHERE Length <> '1/pkg' AND Length <> '2/pkg' AND Length <> '50/pkg'
ORDER BY Length