> 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. myview is a
> view that converts id numbers to the actual names. run, project and name
> come from myview. Both x and y come from the site table.
> Can anyone tell me why the "total" column is empty?
becuase null + <pretty much anything> = null
check out COALESCE:
http://www.postgresql.org/docs/8.1/interactive/functions-conditional.html#AEN12654
Regards,
Richard Broersm Jr.