user3601725
Reputation: 515
Remove one parent record which has two parents records
I have a table which ended up with ParentIDs incorrectly created so that some records are on the same levels as ones which their parent record. For simplicity sake:
| Name | Parent |
|---|---|
| Son | Father |
| Grandson | Son |
| Grandson | Father |
I'm trying to use Inner Joins to remove records where the Name has a Parent which it shares a Parent name with in another record to get rid of the latter.
Upvotes: 0
Views: 14
Answers (0)
Related Questions
- The specified child already has a parent. You must call removeView() on the child's parent first (Android)
- SQL - Update multiple records in one query
- SQL to find emails that have custID 0 AND custID <> 0
- Find records from one table which don't exist in another
- determine row returned when grouping
- SQL: Parent, Child, Subchild, select parents only if all its child has a particular subchild
- Connect child record to parent and grand parents
- SQL Query to select parent that has child records with different values in the same column
- grabbing parent records in sugarcrm