|
-
Nasty Syntax Error
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)
 '
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote