I'm not sure whats going on:

SQL:

Code:
 Select Distinct Products.ProductID, Products.Name, Products.Description, Products.ImageName, Products.Price, Categories.CategoryID, Categories.Name From Products, Categories, Category_Product 
  where Products.ProductID = Category_Product.ProductID and  Category_Product.CategoryID = 4


Results:

Code:
11	Shredded Barks: Walk-on Bark and Shredded Cedar	Decorative mulch used in planter beds to retain soil moisture and inhibit week germination. Stays in place on slopes better than other barks. 221204031002	24	4 Bark
 11	Shredded Barks: Walk-on Bark and Shredded Cedar	Decorative mulch used in planter beds to retain soil moisture and inhibit week germination. Stays in place on slopes better than other barks. 221204031002	24	5 Rocks
 11	Shredded Barks: Walk-on Bark and Shredded Cedar	Decorative mulch used in planter beds to retain soil moisture and inhibit week germination. Stays in place on slopes better than other barks. 221204031002	24	6 Soil
 11	Shredded Barks: Walk-on Bark and Shredded Cedar	Decorative mulch used in planter beds to retain soil moisture and inhibit week germination. Stays in place on slopes better than other barks. 221204031002	24	7 Pavers
 11	Shredded Barks: Walk-on Bark and Shredded Cedar	Decorative mulch used in planter beds to retain soil moisture and inhibit week germination. Stays in place on slopes better than other barks. 221204031002	24	8 Miscellaneous
 13	Pebble/Chip Bark	Small Bark  1 average size Medium Bark  2-3 average size Mini-Bark   average size	Decorative mulch used in planter beds to retain soil moisture and inhibit weed germination. 	221204031231	24 4	Bark
 13	Pebble/Chip Bark	Small Bark  1 average size Medium Bark  2-3 average size Mini-Bark   average size	Decorative mulch used in planter beds to retain soil moisture and inhibit weed germination. 	221204031231	24 5	Rocks
 13	Pebble/Chip Bark	Small Bark  1 average size Medium Bark  2-3 average size Mini-Bark   average size	Decorative mulch used in planter beds to retain soil moisture and inhibit weed germination. 	221204031231	24 6	Soil
 13	Pebble/Chip Bark	Small Bark  1 average size Medium Bark  2-3 average size Mini-Bark   average size	Decorative mulch used in planter beds to retain soil moisture and inhibit weed germination. 	221204031231	24 7	Pavers
 13	Pebble/Chip Bark	Small Bark  1 average size Medium Bark  2-3 average size Mini-Bark   average size	Decorative mulch used in planter beds to retain soil moisture and inhibit weed germination. 	221204031231	24 8	Miscellaneous
 14	Playground Bark	A cedar wood chip primarily used for cushioning under playground equipment. Government-approved as an under-layment.	 221204031642	24	4 Bark
 14	Playground Bark	A cedar wood chip primarily used for cushioning under playground equipment. Government-approved as an under-layment.	 221204031642	24	5 Rocks
 14	Playground Bark	A cedar wood chip primarily used for cushioning under playground equipment. Government-approved as an under-layment.	 221204031642	24	6 Soil
 14	Playground Bark	A cedar wood chip primarily used for cushioning under playground equipment. Government-approved as an under-layment.	 221204031642	24	7 Pavers
 14	Playground Bark	A cedar wood chip primarily used for cushioning under playground equipment. Government-approved as an under-layment.	 221204031642	24	8 Miscellaneous
I'm trying to get one instance of each product back.