Combine tables, duplicate key rows

[skipizza]

I would like to combine three Oracle 8i tables into one. However, when combined there are duplicate key rows. How can I delete them or create the combined table without allowing the dupes? Thanks.

 

[carp]

It would help if you give us the table structures as well as indicating which columns can be joined on and where the duplicate keys are coming from.

 

[skipizza]

All 3 tables have same columns.
SQL> desc acma1
Name Null? Type
-------------------- ------------------
k$$oid NOT NULL VARCHAR2(20)
seq$$ NOT NULL NUMBER(11)
value VARCHAR2(20)

The key fields would be k$$oid and value.

 

[sem]

You may use distinct in your select or just group by all result fields

 

[ninfan]

If you do a UNION in your select query, it will automatically perform the DISTINCT.