Microsoft Access ODBC and queries written in Java
I am currently using IBM Visual Age for Java. I have created a servlet that
connects to a Microsoft Access database. I was wondering what is the correct
syntax to pass a query with a JOIN statement and a where clause.
This an example of the query.
s.executeQuery("SELECT [QPOA].universalAcc, [CRDB].lName, [CRDB].fName, [QPOA].branch,
+"[CRDB].fName from CRDB INNER JOIN QPOA ON [CRDB].universalAcc = [QPOA].universalAcc
Any help would be appreciated
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center