selecting information from two tables (problem)

Поиск
Список
Период
Сортировка
От swatts@computer-systems.com (Shaun)
Тема selecting information from two tables (problem)
Дата
Msg-id f3c408af.0310290753.5b899e77@posting.google.com
обсуждение исходный текст
Список pgsql-general
What I am trying to do is select all the rows out of the categories
table (see below) and select the sum of j_amount out of the judgment
table.  Right now it is only returning the categories that are in the
judgment table.  I want it to return those fields with the amounts out
of the judgment table, but also the all the other categories from the
categories table with 0 as there amount.  Does anyone have a
suggestion.

select ca_code,ca_desc,sum(j_amount) as sum_amt,ca_dis_cycle
from categories LEFT OUTER JOIN judgment ON
(j_category=ca_code)
where j_case_no='45698'
and j_party_no=1
group by ca_code,ca_desc,ca_dis_cycle


thanks,
sw

В списке pgsql-general по дате отправления:

Предыдущее
От: Åsmund Kveim Lie
Дата:
Сообщение: Cartesian product bug?
Следующее
От: Fernando Schapachnik
Дата:
Сообщение: Re: help from Portugal