如何在第二个查询中使用第一个查询的结果？

I have thousands of baskets, each with its own unique id. Millions of balls, each with its own unique Id fill these baskets. Some of those balls are red. My database has millions of records consisting of 3 fields, basketID, ballID, and ball color. I need to return all BallIDs that are in baskets that have a red ball. I figured out queries enough in last few hours to return the BasketID when [Ballcolor] = "RED". Now I'm stuck. I need all records with any basketID included in that result. I'm using Access for the first time since I just realized Excel could only handle a million lines, though I wrote a series of macros and and helper columns to solve it then. A general strategy will work and I can figure out the syntax later. Worst case scenario is I can "clean it up" a million records at a time in Excel before importing them to Access, but that will require a few all nighters I'm not looking forward to. I have thousands of baskets, each with its own