Inner Join subquery in Postgresql results in error

Question

There is my request to find actualities on my website, I got error in this request and I don't know what i need to do for solve this error

Error:

Column "quote_plus_normal_gr_publi.id_post_normal" must appear in the GROUP BY clause or be used in an aggregate fun

Query:

SELECT 
    publi.date, publi.mess, publi, publi.profil, publi.color, 
    publi.name, publi.search
FROM 
    publi
INNER JOIN 
    (SELECT 
         id_post_normal, COUNT(id_post_normal)
     FROM 
         quote_plus_normal_gr_publi
     ORDER BY 
         id_post_normal) q ON q.id_post_normal = publi.id_post_normal
WHERE 
    publi.id_personnes = 1
ORDER BY 
    date DESC

dwir182 · Accepted Answer · 2018-08-29 09:49:42Z

1

I think something wrong in your select statement

SELECT publi.date, publi.mess, publi, publi.profil, publi.color, publi.name, publi.search

FROM publi
INNER JOIN (
    SELECT id_post_normal, COUNT(id_post_normal)
    FROM quote_plus_normal_gr_publi
    ORDER BY id_post_normal
) q 
ON q.id_post_normal = publi.id_post_normal
WHERE publi.id_personnes = 1
ORDER BY date DESC

in first select there are just publi and don't have column to call

select publi.date, publi.mess, publi, publi.profil

so i try query and make similar to you and i don't have any error to show.

first why the error show up group by? do you try another query? not this query?

answered Aug 29, 2018 at 9:49

dwir182

1,54911 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MakeProps Over a year ago

It's that tank you

Collectives™ on Stack Overflow

Inner Join subquery in Postgresql results in error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related