MS Access Query Combining Unsure If to Use a Union Query or Not

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):
Dustin StanleyEntrepreneurAsked:
Who is Participating?
PatHartmanConnect With a Mentor Commented:
If you want the parent data in the same row as the child data (it will look like it repeats), then join the two tables/queries.  If you want the parent data to be separate rows along with child data but not related at all except perhaps by sorting to bring them in some logical order, then use a union.
Dustin StanleyEntrepreneurAuthor Commented:
Ok honestly I have never used a Union Query. I just researched and that is what my gut told me was the best option.
I need the Parent on a seperate row. I also Need the Parents [Skus].[SKU] and the Childrens [qryExport].[ProdConSku] under the same column in the New Query. Maybe just name the Column SKU. How would I go about this and do I have to have the same amount of columns for a Union Query. I am just very unfamiliar with a Union Query.
Thanks Pat!
Dustin StanleyEntrepreneurAuthor Commented:
Ok thanks. I am pretty sure I got it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.