Hi group,
 
I want to ask another sql question. In this example both TaxNumber and "tno" have a integer value. I received an error message from my sql statement.  Can anyone check it?
-------------------------------------------------------------------------
String sql="SELECT  FirstNname, LastName, TaxNumber, SUM(Debt) As Total  FROM " +     
  "Arsa_beyan WHERE TaxNumber=tno GROUP BY TaxNumber, Firstname, Lastname ";
 
following is a error message:
 
java.sql.SQLException:[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.

Reply via email to