SQL join syntax error

You didn't say what result you want so it's a little hard to figure out what is correct.

I am guessing this:

Please Login or Register  to view this content.

This effectively does an inner join.

Hi

Nice alternative but I wanted to figure out the fundamental sql JOIN.

I eventually got their.

This worked:
MyQuery = "Select * FROM NameR Inner Join NameL ON NameL.NameV = NameR.NameW;"

This didnt:
MyQuery = "Select * FROM NameR Join NameL ON (NameV=NameW);"


Unlike true sql you need to be explicit on the join type ie INNER
You need to call out the tables on the join fields.
The code works with or without the join types being bracketed

Oh by the way OUTER join is not supported by MS access and excel vba
You have to got left join, right join and union

Thanks for following up with your solution. I have not had much Access experience but am surprised that outer join is not supported. I have used it in Oracle and MySQL and thought it was standard SQL.