Syntax error ( missing operator ) in query expression of

Question

I have a table in Access 2010 and I want to make a kind INNER JOIN query from several tables I do is the following:

SELECT *
FROM (Archivo Maestro 
         INNER JOIN Concepto Presupuestal 
             ON Archivo Maestro.ID Concepto Presupuestal = Concepto Presupuestal.ID Concepto Presupuestal) 
         INNER JOIN asunto_estrategico 
             ON Archivo Maestro.ID Asunto Estrategico = asunto_estrategico.ID Asunto Estrategico;

but I get an error saying " Syntax error ( missing operator ) in query expression of 'Archivo Maestro.ID Concepto Presupuestal = Concepto Presupuestal.ID Concepto Presupuesta' and the parenthesis not think they are the problems that are there.

ID Concepto Presupuestal Are these column names and table names with spaces? In Access, they must be [] enclosed. as [ID Concepto Presupuestal] or [Concepto Presupuestal] — Michael Berkowski
– Michael Berkowski, Commented May 26, 2015 at 20:15

Rahul · Accepted Answer · 2015-05-26 20:22:09Z

0

Problem is that your table names include space and so query parser/engine taking it as two different literal names. You should escape them using []. Also, notice that I have used table alias (am,cp,ae) for ease of reading. Your query should look like

SELECT am.* FROM [Archivo Maestro] am
INNER JOIN [Concepto Presupuestal] cp ON am.ID = cp.ID 
INNER JOIN [asunto_estrategico] ae ON am.ID = ae.ID;

answered May 26, 2015 at 20:22

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TylerH · Accepted Answer · 2022-03-16 19:49:27Z

0

You should avoid having spaces in table names, columns names, or field names.

Try this one:

SELECT * FROM [Archivo Maestro] INNER JOIN [Concepto Presupuestal] ON ([Archivo Maestro].[ID Concepto Presupuestal] = [Concepto Presupuestal].[ID Concepto Presupuestal]) INNER JOIN asunto_estrategico ON ([Archivo Maestro].[ID Asunto Estrategico] = asunto_estrategico.ID);

Best advice would be to rename all tables and columns using underscore instead of space: Concepto Presupuestal --> Concepto_Presupuestal. This will save you lots of problems.

edited Mar 16, 2022 at 19:49

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered May 26, 2015 at 20:18

Cedric Simon

4,6694 gold badges43 silver badges53 bronze badges

Collectives™ on Stack Overflow

Syntax error ( missing operator ) in query expression of

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related