I thought about that after i typed it, haha, then i thought, i bet he thinks i am loco.. anywany,

here you go....

=====================------------------Categories

if exists (select * from dbo.sysobjects where id =...

I am not posted data on  a forum before, is there a place for me to do that?

in other words it is producing doubles of the PROUCT name from the product table and not getting the ProductCategoryName from the Categories table~~~

It is producing doubles and tripples of that products in the product table and not grabbing the ProductCategoryName for the Categories table.

HERE is where i am

ALTER PROCEDURE GetBlindMenuInfoCTaLL

@IDCompany int

AS

SELECT c.CompanyName, c.CompanyID, ca.ProductCategoryName, p.ProductID

FROM Company C

   JOIN Product P ON C.CompanyId = P.CompanyId

   JOIN Categories CA ON CA.ProductCategoryId = P.ProductCategoryID

WHERE...

I have been on this all day yesterday and i am on it again.

I am not sure what is going on with such a simple query. At this point i...

ok thanks!

Do you know that i am still racking my brain on this one.

MAN if you could help me on this so i can move forward.

I have posted a picture that...

I got it. Man i am always tring to make it hard on myself.

===============================+++++++++++++

 

ALTER PROCEDURE

GetBlindMenuInfoCTaLL

@IDCompany

int

AS

SELECT DISTINCT

Company.CompanyID, Company.CompanyName, Company.CompanyLogo, Product

This is a little better.

ALTER PROCEDURE

GetBlindMenuInfoCTaLL

@IDCompany int

AS

SELECT DISTINCT Company.CompanyID, Company.CompanyName, Company.CompanyLogo, Product.ProductID, Categories.ProductCategoryID, Categories.ProductCategoryName