Hi All,
I want to add x and y. John and Joe do not have a “y”
value, so the LEFT JOIN returns NULL. Likewise Jane does not have a value for “x”
so the LEFT JOIN returns null for her. The “x” and “y” columns
are correct, but I would expect the “total” column to have 24, 232,
and 4. myvi
Thanks Richard! All is working fine now...
> -Original Message-
> From: Richard Broersma Jr [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 03, 2006 10:50 AM
> To: robert.balzli
> Cc: General PostgreSQL List
> Subject: RE: [GENERAL] I can not add up columns when using a left
outer
> joi
