Hello all and thank you for accepting me to the forum.
I have a what is probably a very simple query but one I don't know how to construct, so far I have been working on simple one row queries. A database I am working on has the following rows;
ProductID ProdType Description
1 0 Generator
1 3 Brush Kit
1 6 Bearing Kit
This is simplified and not all ProductIDs will have associated support items. The two queries I would like to construct is one where a ProductID has no associated support items and the second one where a particular ProductID has a duplicated ProductType.
I'm guessing this is just a mindset block in my newby understanding and simple to overcome, thank you in advance for your anticipated help.