Syntax error in FROM clause. (Error 3131)

Question

I used Access to construct this query by default it uses an inner join, but when I change it to outer I get this error. Any ideas? Thanks, in advance.

SELECT hotRods.Make, hotRods.Model, hotRods.Year, vertex.Make, vertex.Model, vertex.Year, hotRods.[Part #], vertex.[Part #]
FROM vertex 
FULL JOIN hotRods 
ON (vertex.Year = hotRods.Year) AND (hotRods.Model = vertex.Model) 
AND (vertex.Make = hotRods.Make) AND (RIGHT(hotRods.[Part #], 6) = RIGHT(vertex.[Part #],6));

Possible duplicate of [How do I write a full outer join query in access](http://stackoverflow.com/questions/19615177/how-do-i-write-a-full-outer-join-query-in-access) — Zein Makki, Jul 15 '16 at 15:17

score 0 · Accepted Answer · answered Jul 15 '16 at 16:47

SELECT hotRods.Make, hotRods.Model, hotRods.Year, vertex.Make, vertex.Model, vertex.Year, hotRods.[Part #], vertex.[Part #]
FROM vertex 
Left outer join hotRods 
ON (vertex.Year = hotRods.Year) AND (hotRods.Model = vertex.Model) 
AND (vertex.Make = hotRods.Make) AND (RIGHT(hotRods.[Part #], 6) = RIGHT (vertex.[Part #],6))
union 
SELECT hotRods.Make, hotRods.Model, hotRods.Year, vertex.Make, vertex.Model, vertex.Year, hotRods.[Part #], vertex.[Part #]
FROM vertex 
right outer join hotRods 
ON (vertex.Year = hotRods.Year) AND (hotRods.Model = vertex.Model) 
AND (vertex.Make = hotRods.Make) AND (RIGHT(hotRods.[Part #], 6) = RIGHT(vertex.[Part #],6))

Syntax error in FROM clause. (Error 3131)

1 Answers1