Annoying syntax error

[jooey]

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!

 

[SteveSchapel]

Jooey,

I am not certain this will be the only problem, but for a start you can drop the word "OUTER". I am pretty sure your parentheses are in the wrong place too.

Why not create the query using Access's query designer, and then look at the SQL view to see what you get?

 

[jooey]

Jooey,

I am not certain this will be the only problem, but for a start you can drop the word "OUTER". I am pretty sure your parentheses are in the wrong place too.

Why not create the query using Access's query designer, and then look at the SQL view to see what you get?

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

 

[jooey]

parenthesis it was. Opening parenthesis was after FROM

It's good when you are not on your own

Thanks!