• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 136
  • Last Modified:

MS Access 2010 Query

I have a basic query below in Microsoft Access 2010. I am getting an error on the FROM clause.     Thanks for any info.
Select * From Customer
JOIN Address ON Customer.CustomerID=Address.CustomerID
WHERE Address.ZipCode ='12345'
0
fjkaykr11
Asked:
fjkaykr11
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try this

Select * From Customer
INNER JOIN Address ON Customer.CustomerID=Address.CustomerID
 WHERE Address.ZipCode ='12345'
0
 
fjkaykr11Author Commented:
thanks.  I will have to get back to you tomorrow to see if it worked (I am sure it will)
0
 
fjkaykr11Author Commented:
it works, thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now