CODEWITHSUNDEEP
sqlms-access
ziggy
ziggy

Reputation: 1538

Access simple SQL join

very simple SQL join in Access. fields are both text. 

SELECT * from
houses join munzip
on
houses.MUN_CODE = munzip.GOOD MUN;

giving me this error

Syntax error (missing operator) in query expression 'houses.MUN_CODE = munzip.GOOD MUN'

there all some nulls in the houses.MUN_CODE field

I am new to SQL so please don't bash me.

Upvotes: 0

Views: 54

Answers (1)

Pham X. Bach
Pham X. Bach

Reputation: 5442

You should use this:

SELECT * 
from houses 
inner join munzip
    on houses.MUN_CODE = munzip.[GOOD MUN];

SQL queries don't accept names with a space, so in Access you should surround it with square brackets.

Upvotes: 1

Related Questions