sql help

[erikkl2000]

If you will notice in the bottom left hand corner the ProductCategoryName Column is producing two and three results on the same product and these products are not in the categories table, this categories table is where the ProductCategoryName is at so i am not sure what is going on here.

I am including a photo on a url so that you may have a look at the web site.

http://afcc1.com/sqlHELP

==============================================
I NEED the ProductID , ProductCategoryName , and the CompanyID

WHERE the companyid = @idcompany

and Categories.Productcategoryid = 20 (0r something like this)
=============================================

I need someone who has knows sql to take a peek at this and let me know what i need to add or do to receive the proper result.
Thank you!

http://afcc1.com/sqlHELP

Erik

[Rawhide]

They all have different product ID's and product names. The ProductCategoryName is being returned multiple times because multiple products have that ProductCategoryName.

The results are correct.