content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: selecting problems
Date: Fri, 31 Oct 2003 14:19:49 -0500
Message-ID: 
 <6A1C87CA83BA8C419B1262B3728B12D102D435@csiserv1.computer-systems.com>
Thread-Topic: selecting problems
Thread-Index: AcOf4/Oo6Ft1DnIBT0uhaAyZqEc1Tw==
From: "Shaun Watts" <SWatts@computer-systems.com>
To: <pgsql-sql@postgresql.org>


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=3Dca_code)
where j_case_no=3D'45698'
and j_party_no=3D1
group by ca_code,ca_desc,ca_dis_cycle

Thanks,
Shaun
---------------------------------------------------------------------=20
Shaun, <mailto:swatts@computer-systems.com>=20
Phone 1-317-913-4160 Fax 1-317-913-4175=20
CSI - Computer Systems, Inc. <http://www.computer-systems.com/>
"Dictionary is the only place that success comes before work. Hard work is =
the price we=20
must pay for success. I think you can accomplish anything if you're willing=
 to pay the price."
Vince Lombardi=20