Tyler Kellen <sleekcode(at)gmail(dot)com> writes:
> Why is my discount total different when I
> left join the trans table to the totals?
Are you sure that trans_item.trans_id is unique and accounts for all the
existing values of trans.id? I don't see any unique index or foreign
key constraints in your \d output, so the database isn't enforcing that
condition for you ...
regards, tom lane