sum from table 1, where from table 2
От | John Smith |
---|---|
Тема | sum from table 1, where from table 2 |
Дата | |
Msg-id | CAMZ8qd_-5QsNjHD8N5yfyDWmGEuhna5b766QDEPfjT9kb+WRQQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: sum from table 1, where from table 2
Re: sum from table 1, where from table 2 |
Список | pgsql-general |
i have two tables, like so: 1. create table public.vote ( sn integer primary key, total integer, city varchar(24) ); sn | total | city 1 | 11 | new york 2 | 27 | los angeles 3 | 58 | san diego 2. create table public.state ( sn integer primary key, st varchar(2), city varchar(24) ); sn | st | city 1 | ny | new york 2 | ca | los angeles 3 | ca | san deigo i am looking for a result, like so: st | total ca | 85 ny | 11 but this doesn't work: select sum(vote.total), state.st from public.vote, public.state where vote.city = state.city group by state.st order by sum(vote.total) desc; subquery? having? thanks, jzs
В списке pgsql-general по дате отправления: