This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression 'B.BNUMBER=T.BUY_BILL) AS BUY_DATE, BUY_PRICE, BUY_VENDOR, SELL_BILL,(SELECT B.BDATE FROM BILLS AS B WHERE B.BNUMBER=T.SELL_BILL) AS SELL_DATE, SELL_PRICE, SELL_VENDOR FROM TRADES T'.
but the same query runs fine in MS access....when run independently of java....
I am using MS Access as the Databse [ November 27, 2006: Message edited by: Bear Bibeault ]