Cannot understand this error

[Vaibhav Pingle]

Hi frnds.....

On running the following query......

ResultSet rs = stmt.executeQuery("SELECT stock, qty, buy_bill,(SELECT b.bdate FROM Bills AS b WHERE 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 ORDER BY stock");

i am getting the following error......

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 ]