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
Bookmarks