SQL Syntax Error

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

On Wed, 3 Nov 2004 23:52:04 -0800, "Wantula"
wrote:

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
--
www.kcc.ch

On Wed, 3 Nov 2004 23:52:04 -0800, "Wantula"
wrote:

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

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/For...sdbdesign/6314
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abu...edc6e67dc65901
*****************************************