-
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)
'
-
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
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
|
|