Search results

  1. J

    Annoying syntax error

    parenthesis it was. Opening parenthesis was after FROM It's good when you are not on your own :) Thanks!
  2. J

    Annoying syntax error

    with and without outer it generates syntax error . Parantheses are needed in multiple joins according to various sources - Here is an example http://www.ehow.com/how_4583245_join-multiple-tables-relational-database.html
  3. J

    Annoying syntax error

    Hello, I started recently learning SQL on MS Access 2003. I get an error message running this query and I don't know what the problem could be SELECT A.* ( FROM A LEFT OUTER JOIN [5b] ON A.ID = [5b].ID ) LEFT OUTER JOIN c ON A.ID = c.ID WHERE [5b].ID IS NULL AND c.ID IS NULL; Thanks!
Back
Top Bottom