{"id":28768,"date":"2023-01-02T14:03:51","date_gmt":"2023-01-02T08:33:51","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/"},"modified":"2023-01-02T14:03:51","modified_gmt":"2023-01-02T08:33:51","slug":"solved-mysql-error-unknown-column-in-having-clause","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/","title":{"rendered":"[Solved] MYSQL error Unknown column in &#8216;having clause&#8217;"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-47538633\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"47538633\" data-parentid=\"47536126\" data-score=\"1\" data-position-on-page=\"2\" data-highest-scored=\"0\" data-question-has-accepted-highest-score=\"0\" itemprop=\"suggestedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>finally I found the solution, rename the variable date and change it in the sentence having.<\/p>\n<pre><code>SELECT\n    creditos.NombreCliente,\n    creditos.Contrato,\n    creditos.Rut,\n    creditos.lIdtplCabezaCotiza,\n    creditos.FechaPagare,\n    creditos.FechaCurse,\n    creditos.FechaVcto1,\n    creditos.FechaVcto2,\n    creditos.FormaPago,\n    creditos.EstadoMandato,\n    REPLACE (CuentaCorriente, ',', '.') AS CuentaCorriente,\n    creditos.Sucursal,\n    creditos.cFyI,\n    creditos.FechaUltimoPago,\n    estado_creditos_banco.`Fecha Activaci\u00f3n` AS FechaActivacion,\n    estado_creditos_banco.`Detalle de Rechazo` AS DetalleRechazo,\n    MAX(\n        estado_creditos_banco.`Fecha Recepci\u00f3n CCA`\n    ) as fecha,\n    estado_activos_banco.Observaciones,\n    estado_creditos_banco.`Estado General` AS EstadoActivacion,\n    creditos.EmailCliente,\n    REPLACE (\n        creditos.TelefonosCliente,\n        ',',\n        '-'\n    ) AS Telefono\nFROM\n    creditos\nLEFT JOIN estado_creditos_banco ON estado_creditos_banco.Identificador = creditos.lIdtplCabezaCotiza\nLEFT JOIN estado_activos_banco ON estado_activos_banco.`# Cotiz` = creditos.lIdtplCabezaCotiza\nWHERE\n    `creditos`.`Estado` = \"CURSADA\"\nAND 1 = 1\nGROUP BY\n    Identificador\nHAVING\n    fecha = MAX(\n        estado_creditos_banco.`Fecha Recepci\u00f3n CCA`\n    )\nLIMIT 0,\n 300\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved MYSQL error Unknown column in &#8216;having clause&#8217; <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] finally I found the solution, rename the variable date and change it in the sentence having. SELECT creditos.NombreCliente, creditos.Contrato, creditos.Rut, creditos.lIdtplCabezaCotiza, creditos.FechaPagare, creditos.FechaCurse, creditos.FechaVcto1, creditos.FechaVcto2, creditos.FormaPago, creditos.EstadoMandato, REPLACE (CuentaCorriente, &#8216;,&#8217;, &#8216;.&#8217;) AS CuentaCorriente, creditos.Sucursal, creditos.cFyI, creditos.FechaUltimoPago, estado_creditos_banco.`Fecha Activaci\u00f3n` AS FechaActivacion, estado_creditos_banco.`Detalle de Rechazo` AS DetalleRechazo, MAX( estado_creditos_banco.`Fecha Recepci\u00f3n CCA` ) as fecha, estado_activos_banco.Observaciones, estado_creditos_banco.`Estado &#8230; <a title=\"[Solved] MYSQL error Unknown column in &#8216;having clause&#8217;\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\" aria-label=\"More on [Solved] MYSQL error Unknown column in &#8216;having clause&#8217;\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,341],"class_list":["post-28768","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] MYSQL error Unknown column in &#039;having clause&#039; - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] MYSQL error Unknown column in &#039;having clause&#039; - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] finally I found the solution, rename the variable date and change it in the sentence having. SELECT creditos.NombreCliente, creditos.Contrato, creditos.Rut, creditos.lIdtplCabezaCotiza, creditos.FechaPagare, creditos.FechaCurse, creditos.FechaVcto1, creditos.FechaVcto2, creditos.FormaPago, creditos.EstadoMandato, REPLACE (CuentaCorriente, &#039;,&#039;, &#039;.&#039;) AS CuentaCorriente, creditos.Sucursal, creditos.cFyI, creditos.FechaUltimoPago, estado_creditos_banco.`Fecha Activaci\u00f3n` AS FechaActivacion, estado_creditos_banco.`Detalle de Rechazo` AS DetalleRechazo, MAX( estado_creditos_banco.`Fecha Recepci\u00f3n CCA` ) as fecha, estado_activos_banco.Observaciones, estado_creditos_banco.`Estado ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-02T08:33:51+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] MYSQL error Unknown column in &#8216;having clause&#8217;\",\"datePublished\":\"2023-01-02T08:33:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\"},\"wordCount\":34,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\",\"name\":\"[Solved] MYSQL error Unknown column in 'having clause' - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-02T08:33:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] MYSQL error Unknown column in &#8216;having clause&#8217;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] MYSQL error Unknown column in 'having clause' - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] MYSQL error Unknown column in 'having clause' - JassWeb","og_description":"[ad_1] finally I found the solution, rename the variable date and change it in the sentence having. SELECT creditos.NombreCliente, creditos.Contrato, creditos.Rut, creditos.lIdtplCabezaCotiza, creditos.FechaPagare, creditos.FechaCurse, creditos.FechaVcto1, creditos.FechaVcto2, creditos.FormaPago, creditos.EstadoMandato, REPLACE (CuentaCorriente, ',', '.') AS CuentaCorriente, creditos.Sucursal, creditos.cFyI, creditos.FechaUltimoPago, estado_creditos_banco.`Fecha Activaci\u00f3n` AS FechaActivacion, estado_creditos_banco.`Detalle de Rechazo` AS DetalleRechazo, MAX( estado_creditos_banco.`Fecha Recepci\u00f3n CCA` ) as fecha, estado_activos_banco.Observaciones, estado_creditos_banco.`Estado ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/","og_site_name":"JassWeb","article_published_time":"2023-01-02T08:33:51+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] MYSQL error Unknown column in &#8216;having clause&#8217;","datePublished":"2023-01-02T08:33:51+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/"},"wordCount":34,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/","url":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/","name":"[Solved] MYSQL error Unknown column in 'having clause' - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-02T08:33:51+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-error-unknown-column-in-having-clause\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] MYSQL error Unknown column in &#8216;having clause&#8217;"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/28768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=28768"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/28768\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=28768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=28768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=28768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}