Tyler Kellen <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
