Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: Syntax Error in FROM clause . . .

    This was posted on the Microsoft Help site.

    The error I get is "Syntax error in FROM clause."

    I can't see it?

    Code:
    SELECT ClosingPrice, AVG(Median) as Median FROM
    (
    
    SELECT x.ClosingPrice, x.Value AS Median
    FROM ClosingPrice x
    
    INNERJOIN closingPrice y
    ON x.ClosingPrice = y.ClosingPrice
    HAVING SUM(SIGN(x.value-y.Value)) IN (1,0,-1)
    ) A

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    If you have space in your fieldnames, you need to [square bracket] the field name. So like [ClosingPrice x].

    Else consider using a better naming convention.
    Me.Geek = True

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i would say it's because you're missing at least one space between INNER and JOIN

    plus the fact that your GROUP BY clause is missing

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •