see use '%' at the place of '*' like this public String Generage_SQL() { // string mySELECTStr, myFROMstr, myCriteriaStr, myOrderByStr, mySQLstring; mySELECTStr = "SELECT Library.Title, Author.Lastname, Author.Firstname, Publisher.PublisherName, Library.PublishYear, Subject.SubjectName, MediaType.MediaTypeName, Library.NumberOfCopy , Library.DateUpdate, MediaType.MediaTypeID, Subject.SubjectID, Library.Description, Library.BiographyName, Library.DateUpdate " ; myFROMstr