SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Non-Member
    Join Date
    Aug 2007
    Posts
    494
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ErrorNr. 1064 in MySQL server version

    Hi all.

    I try this query in the db MySQL:

    Code:
         SELECT
         A.ID,
         A.DG,
         A.ES,
         A.ZA,
         A.IM,
         A.LT,
         A.LO,
         A.CL,
         A.OR,
         A.MN,
         A.CS,
         A.DU,
         A.CA,
         A.EL,
         A.MO,
         A.TC,
         A.FR,
         A.RG,
         A.CM,
         A.AV,
         A.DT,
         A.IN,
         CA.NR, CA.DU
         (A.CL*CA.NR)+(A.AV*CA.DU)
         FROM
         doTable_1 A,
         doTable_2 CA
         WHERE
         A.LT = CA.LT
         AND
         ES = 'DX'
         AND
         DG = '2008-11-13'
         ORDER BY ZA asc"
    But receive this error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"' at line 34
    ErrorNr. 1064

    Can you help me?
    kind regards
    viki

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,268
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    put a comma after CA.DU
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Non-Member
    Join Date
    Aug 2007
    Posts
    494
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    put a comma after CA.DU
    Sorry... I sleep...


Bookmarks

Posting Permissions

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