LEFT OUTER JOIN

Question

LEFT OUTER JOIN

Navigation

#1 by (0 votes)

1

I have a table in PostgreSQL. I would like to count two columns where one has more record than the other. If I use LEFT OUTER JOIN I think it will work, though, I'm not getting with the PostgreSQL syntax. The command I am using is as follows:

SELECT codmunic, ene_ine, count(loc) as energia_ine
from tabela a left join
    (SELECT codmunic, COUNT(loc) as energia_ine
      FROM tabela
      WHERE ene_ine = 's'
      GROUP BY codmunic) as ag_caim
      using (codmunic)
      group by codmunic;

sql postgresql

asked by anonymous 15.06.2018 / 16:48

1 answer

Why nohup does not accept for loop? Register "https" protocol with certificate for SOAP request (Axis 2)

score 0 · Answer 1

Maybe you do not need any kind of JOIN to make this comparative count, see:

SELECT
    codmunic,
    ene_ine,
    count(loc) as energia_ine
FROM
    tabela
GROUP BY
    codmunic,
    ene_ine
ORDER BY
    codmunic,
    ene_ine;