SQL Syntax Error

[Guest]

Lynn Trapp asked me to post the actual SQL code so that it can be checked for
error. The error is "Syntax error in FROM clause."

SELECT Stock.Item, Sum(Stock.Quantity),
Sum(Sales.[Item Bought])
FROM Stock JOIN ON Stock.Item = Sales.Item Bought
GROUP BY Stock.Item

 

[Matthias Klaey]

Lynn Trapp asked me to post the actual SQL code so that it can be checked for
error. The error is "Syntax error in FROM clause."

SELECT Stock.Item, Sum(Stock.Quantity),
Sum(Sales.[Item Bought])
FROM Stock JOIN ON Stock.Item = Sales.Item Bought
GROUP BY Stock.Item

SELECT Stock.Item, Sum(Stock.Quantity),
Sum(Sales.[Item Bought])
FROM Stock JOIN Sales ON Stock.Item = Sales.[Item Bought]
GROUP BY Stock.Item

HTH
Matthias Kläy

 

[John Vinson]

Lynn Trapp asked me to post the actual SQL code so that it can be checked for
error. The error is "Syntax error in FROM clause."

SELECT Stock.Item, Sum(Stock.Quantity),
Sum(Sales.[Item Bought])
FROM Stock JOIN ON Stock.Item = Sales.Item Bought
GROUP BY Stock.Item

You're not specifying the SALES table: should be

FROM Stock JOIN Sales ON Stock.Item = Sales.[Item Bought]

You need the name of the table to which you are joining, and if you
(unwisely, IMO) use blanks in fieldnames, you need brackets around the
fieldname.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[David Seeto via AccessMonster.com]

ARGH! I seem to have wasted my time and effort replying to your initial post - this is why I would ask you to not post the same question multiple times!!! Update your previous post if you need a clarification!

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/Uwe/Forum.aspx/access-tablesdbdesign/6314
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=d437c3ac2b4f4ccfacedc6e67dc65901
*****************************************