ODBC to ACCESS query (huge headache)

E

Eddy

Need help here. I am trying to run a query using odbc to extract data from my
access database. This is what my query looks like.

SELECT customers.*, [customer needs].* FROM { customers INNER JOIN [customer
needs] ON customers.customerID = [customer needs].customerID }

It keeps giving me an error on customers.customerID = [customer
needs].customerID }


I can retrieve data from [customer needs] alone and customers alone but this
inner join via odbc is killing me. Can anyone help me out?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top