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,
[QPOA].accountNumber, "
+"[CRDB].fName from CRDB INNER JOIN QPOA ON [CRDB].universalAcc = [QPOA].universalAcc
where [(QPOA].[accountNumber]=\"12345\";");
Any help would be appreciated