jdbc-msAccess

[med bill]

i have problems querying tables using sql Join type with jdbc on MsAccess. Does MsAccess use diferent SQL type commands, do u know where can i get it.
I am trying to develop some appl. that use JDBC against an Ms Access database. thanks

[Joe Paolangeli]

I have coded table joins using JDBC and MS Access. I found that was very usefull to first develop a query in MS Access to fix any possible syntax errors. Here is a sample table join query:

select A.first_name
     , A.last_name
     , B.street
     , B.city
     , B.zip
  from customer as A
     , address  as B
 where A.last_name  = 'Smith' 
   and A.customerId = B.customerId

Let me know if this helps.
[This message has been edited by Joe Paolangeli (edited October 27, 2000).]

[Monty Ireland]

Any basic DML sql should work...
I you are using the jdbc-odbc driver provider with the standard jdk. Take a few minutes to review the demo/sample code.
Or, search this form for jdbc-odbc sample code.
Go back about 60 days... you will find alot of complete program examples.

------------------
We learn more from our mistake's than from our success's.
a.k.a. monty6

[med bill]

Thanks guys..
it works for me...