: Ошибочное или пропущенное зарезервированное слово или аргумент в инструкции SELECT или неверная пунктуация.Ī> A> String SQL_GET_USERS = "SELECT TOP 5 user.id, user.firstName, user.lastName, userInfo.phone, profession.name AS profession " +Ī> "FROM INNER JOIN (profession INNER JOIN userInfo ON profession.id=userInfo.professionId) ON user.id=erId " +Ī> "WHERE user.id not in (select TOP ? id from user) ORDER BY user.id " Ī> PreparedStatement prepStatement = connection.prepareStatement(SQL_GET_USERS) Ī> ResultSet resultset = prepStatement.executeQuery() Ī>: Ошибка синтаксиса. String SQL_GET_USERS = "SELECT TOP ? user.id, user.firstName, user.lastName, userInfo.phone, profession.name AS profession " + ResultSet resultset = prepStatement.executeQuery() PreparedStatement prepStatement = connection.prepareStatement(SQL_GET_USERS) "WHERE user.id not in (select TOP ? id from user) ORDER BY user.id " "FROM INNER JOIN (profession INNER JOIN userInfo ON profession.id=userInfo.professionId) ON user.id=erId " + String SQL_GET_USERS = "SELECT TOP 5 user.id, user.firstName, user.lastName, userInfo.phone, profession.name AS profession " +
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |