Re: [SQL] FULL OUTER JOIN Question

Tyler Kellen <[EMAIL PROTECTED]> writes: > I have a question about a full outer join returning duplicate rows. Why do you think they are duplicate? The GROUP BY includes many columns that you can't see directly in the output ... Also, you did not show us the actual input data (where's the rows w

[SQL] FULL OUTER JOIN Question (mistake)

The first query under 'BAD RESULT:' doesn't have anything to do with my question Please disregard it!   mg=# select * from trans_item where id=20116;   id   | trans_id | parent | qty | item_sku | item_price | item_tax ---+--++-+--++--  20116 |    

[SQL] FULL OUTER JOIN Question

I have a question about a full outer join returning duplicate rows.   I have one table that stores a record for each transaction with totals: CREATE TABLE trans (   id  serial PRIMARY KEY,   stamp   timestamp DEFAULT now(),   trans_type_id   int NOT NULL REFERENCES trans_type(id