Try this, String sql="SELECT FirstNname, LastName, TaxNumber, SUM(Debt) As Total FROM " + "Arsa_beyan WHERE TaxNnumber = '"+tno+"' GROUP BY TaxNumber, Fname, Lname ";
observe this change ------ TaxNnumber = '"+tno+"' Hope this helps. Srinivas ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
