Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Unanswered: syntax error in FROM

    Hi this is my first message
    sorry for my terrible english, i'll try to write correctly! :-)

    I got this trouble:
    it seems to be an error in FROM of this query but i'm unable to find it, can you help me?

    SELECT tabA.field1, tabA.field2, tabA.field3, tabB.field1, tabB.field2, tabB.field3 FROM tabA IN 'D:\Dati\......\listino.mdb' LEFT JOIN TabB ON (TabA.field4 = tabB.field4) WHERE tabA.field5 = 'X' AND tabA.field6='Y' AND tabB.field5= 'Z'

    the connection is made on database that contains TabB (that's why I'm using "FROM tabA IN 'physical path of database that contains tabA')

    IMPORTANT: If i remove the left join it works correctly....

    suggestions? tips? tricks?
    thank you
    bye
    Last edited by supermac; 03-03-05 at 05:00.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    I don't see where tabA is ever defined in your SQL statement.

    So here is a guess - you may want to try something like this (AS tabA is added to what you already had):

    SELECT tabA.field1, tabA.field2, tabA.field3, tabB.field1, tabB.field2, tabB.field3 FROM tabA IN 'D:\Dati\......\listino.mdb' AS tabA LEFT JOIN tabB ON (tabA.field4 = tabB.field4) WHERE tabA.field5 = 'X' AND tabA.field6='Y' AND tabB.field5= 'Z'
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Mar 2005
    Posts
    2
    uh, I already solved my troubles splitting the query in 2 queries....
    I think I tried even to write "AS tabA", as you suggested, with the same result...
    thank you however
    bye

Posting Permissions

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