Syntax error apparently - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Syntax error apparently

Author

Topic

djbomb95
Starting Member

9 Posts

Posted - 2012-09-04 : 05:55:20

SELECT SUM(IngPrice)
FROM SingleItem
WHERE Ingname IN
(SELECT IngName
FROM Toppings
WHERE PizzaName IN
(SELECT PizzaName
FROM PizzaOrder
WHERE OrderID = 57))
OR IngName IN
(SELECT IngName
FROM ItemsAdded
WHERE PizzaID IN
(SELECT PizzaID
FROM Order
WHERE OrderID = 57))
AND IngName NOT IN
(SELECT IngName
FROM ItemsRemoved
WHERE PizzaID IN
(SELECT PizzaID
FROM Order
WHERE OrderID = 57));

I am told by ms access 2010 that I have made a syntax error somewhere from line 11 to 16. It seems to be formatted correctly, and all of the names of tables and columns and such are correct. This is for an assignment on user interface. As you have possibly guessed, it is about a pizza shop. Thanks for any help. David

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2012-09-04 : 06:02:06

Order is a reserved word, either put it in "" or [].

djbomb95
Starting Member

9 Posts

Posted - 2012-09-04 : 06:08:32

Thanks. Just for anyone in future who has issues with this. This is the revised, and working query:

SELECT SUM(IngPrice)
FROM SingleItem
WHERE Ingname IN
(SELECT IngName
FROM Toppings
WHERE PizzaName IN
(SELECT PizzaName
FROM PizzaOrder
WHERE OrderID = 57))
OR IngName IN
(SELECT IngName
FROM ItemsAdded
WHERE PizzaID IN
(SELECT PizzaID
FROM [Order]
WHERE OrderID = 57))
AND IngName NOT IN
(SELECT IngName
FROM ItemsRemoved
WHERE PizzaID IN
(SELECT PizzaID
FROM [Order]
WHERE OrderID = 57));

Thanks again RickD.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources