hi, We have two tables with the same structure some users insert data in the first table and the others insert the same data into the another table the all users can duplicate insert the data again by mistak .. there is no uniqe index , no foreign key ,no primary key ..So I want to delete the identically rows which inserted into two tables and display the records which inserted in one table and not inserted in another table as this example:
table A , table B
1 , 1
1 , 1
1 , 2
2 , 2
2 , 2
3 , 4
5 , 5
7 , 6
8 , 6
6 , 8
and I want the result will be :
1 , 4
3 , 2
7 , 6
thanks.