Hi,
replace: .....TaxNumber=tno...... with : ....TaxNumber= '"+tno+"' GROUP BY ....... and try 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: 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