No, I need the output to be like I showed in the first post
I think I found a way. This may not be the best way (using the GUI)
I create Query for each sub query.
On TopQuery: SELECT outfits.TopColorID, Colors.Color
FROM Colors INNER JOIN outfits ON Colors.ID = outfits.TopColorID;
On BottomQuery: SELECT outfits.BottomColorID, Colors.Color
FROM Colors INNER JOIN outfits ON Colors.ID = outfits.BottomColorID;
I can create these using the GUI easily.
Then on the main query, I add the above queries and link them. Then can select the color names from the appropriate query.