I have a list of items Part 1, Part 2, Part 3, Part 4 and Part 5, associated with ID numbers, as follows:
ID | Item
-- | ----
1 | Part 1
1 | Part 2
1 | Part 3
1 | Part 4
2 | Part 1
2 | Part 2
2 | Part 4
2 | Part 5
3 | Part 2
3 | Part 4
3 | Part 5
I would like a result set of each Part that is NOT found per ID in the Part column, as follows:
ID | Item
-- | ----
1 | Part 5
2 | Part 3
3 | Part 1
3 | Part 3
Can anyone help with the SQL query to generate my solution recordset?
Regards,
Wayne