How to delete duplicate records in from multiple tables in SQL oracle?

Question

in the image, these are the records in my tables from two different tables which are linked together through the "CUSTABN". As the records from these tables are duplicated, so I want to delete all the duplicate records.

Records from multiple tables (Customer & Invoice)

Can anyone help?

want to delete duplicates or want to select distinct values from 2 tables ? — M.mhr
– M.mhr, Commented Apr 21, 2016 at 14:39
I want to delete the duplicate records from two tables that is linked together. the tables is in the link on top of this page (Records from multiple tables (Customer & Invoice)) — Agus Maloco
– Agus Maloco, Commented Apr 21, 2016 at 14:40
are you sure the data are duplicated and are not the result of a join ?... in this case you need a select distinct and not a delete .. — ScaisEdge
– ScaisEdge, Commented Apr 21, 2016 at 14:43
that records are combination of both tables. but is it possible to delete? — Agus Maloco
– Agus Maloco, Commented Apr 21, 2016 at 14:46

M.mhr · Accepted Answer · 2016-04-21 14:53:07Z

1

If your tables are related with foreign key field "CUSTABN", I think this is what you want :

DELETE T1, T2 FROM T1 JOIN T2 ON T1.CUSTABN = T2.CUSTABN WHERE ...

answered Apr 21, 2016 at 14:53

M.mhr

1,7592 gold badges24 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Agus Maloco Over a year ago

would you please make a clear query because am stuck on how to delete records from two related tables

M.mhr Over a year ago

You can use this query without any condition ( without WHERE clause ) and it will delete all records returned from join ( duplicate records ), but first test it on two test table to ensure that I correctly discovered what you want !

Collectives™ on Stack Overflow

How to delete duplicate records in from multiple tables in SQL oracle?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related