{DIFFICULT} Making list of unique values from info in two tables

I have two tables. One contains a list of relevant customer numbers, the other has the relevant customer numbers along with workorder numbers mixed in with irrelevant customers/workorders. There is at least one workorder per customer number, but there may be multiple workorders per customer number.

I need to make a third table containing only the relevant customers in one column with each unique workorder for that customer in another column.

In other words, is there a way to say, "look for these customer numbers in table 2 and give me a list of all the workorders that pertain to them?"

See the attached!

Thanks