Nasty Syntax Error

[erikkl2000]

I am receiving a nasty syntas error and i have just about lost my mind.
Error-- Syntax error near 'WHERE

PLEASSSSSSSSSSSSSSEEE HELP!
-----------------------------------------------------------
ALTER PROCEDURE GetBlindMenuInfoCTaLL

@IDCompany int

AS

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

FROM Company INNER JOIN

Product ON Company.CompanyID = Product.CompanyID

INNER JOIN

Categories ON Categories.ProductCategoryID = Product.ProductCategoryID

WHERE Company.CompanyID = @IDCompany

AND

WHERE IN (Select Categories.ProductCategoryID from Categories where Categories.CategoryTypeid = 20)
'

[Rawhide]

First off, you can only have 1 WHERE clause. Secondly, you have an IN clause, but you don't say what should be in it.

ALTER PROCEDURE GetBlindMenuInfoCTaLL
@IDCompany int
AS

SELECT DISTINCT Company.CompanyID, Company.CompanyName, Company.CompanyLogo, Product.ProductID, Categories.ProductCategoryID, Categories.ProductCategoryName
FROM Company
INNER JOIN Product ON Company.CompanyID = Product.CompanyID
INNER JOIN Categories ON Categories.ProductCategoryID = Product.ProductCategoryID
WHERE Company.CompanyID = @IDCompany
AND Categories.CategoryTypeid = 20