OK, I think I found a way. 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.

OK, 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.