sql error

[JToe]

Hi all..

I have a sql statement like this :

String query ="Select GL.GLDescriptio n AS Expense," +
"(Select SUM(Transaction .ECFAmount) From Transaction Where month(Transacti on.Date)=1 AND GL.GLCode=Trans action.GLCode) AS Jan," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=2 AND GL.GLCode=Trans action.GLCode) AS Feb," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=3 AND GL.GLCode=Trans action.GLCode) AS Mar," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=4 AND GL.GLCode=Trans action.GLCode) AS Apr," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=5 AND GL.GLCode=Trans action.GLCode) AS May," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=6 AND GL.GLCode=Trans action.GLCode) AS Jun," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=7 AND GL.GLCode=Trans action.GLCode) AS Jul," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=8 AND GL.GLCode=Trans action.GLCode) AS Aug," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=9 AND GL.GLCode=Trans action.GLCode) AS Sept," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=10 AND GL.GLCode=Trans action.GLCode) AS Oct," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=11 AND GL.GLCode=Trans action.GLCode) AS Nov," +
"(Select SUM(Transaction .Amount) From Transaction Where month(Transacti on.Date)=12 AND GL.GLCode=Trans action.GLCode) AS Dec," +
"(Select SUM(Transaction .Amount) From Transaction Where GL.GLCode=Trans action.GLCode) AS Total" +
"INTO Empexpense" +
"FROM GL, Transaction" +
"Where GL.GLCode=Trans action.GLCode AND Transaction.Emp loyeeNumber=" + empID +
"GROUP BY GL.GLCode";

I get an sql error after running this statement.

"java.sql.SQLEx ception: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."

Pls help me clarify what might be the problem?

Thanks in advance

[NeoPa]

Try chopping out various of the lines until you find a much smaller version that exhibits your problem.
This will probably help you to understand the problem yourself anyway.
If not, repaste the new, much smaller SQL code in here within the code tags and formatted to be visible within the space available (That means not just one long line of SQL) and we'll see what we can do for you.