• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • 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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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