In my setup I have Parent Products and Product Variations (Children). Table [SKUs] is the Parents and Table [Products] is the Children. I have successfully made multiple Select Queries to come up with a final Children Queries result. This Result includes all the Children and their attributes.
The final part that I can not come up with is how to also Insert the Parents into this list. In the End Result I need my list to have the parents and the children together. Reunite the family ;)
Do I use a Union Query or what?
Here is an example image of what I need:
Here is some of my Children Results currently (ProdConSku is the Children SKU):