I'm very new to access - perhaps this is an easy one...
I have a master table 2 columns wide. I want to extract data from the master table for values that appear in a second table.
That is...
Master Table:
1 a
1 b
3 c
4 d
4 e
6 f
6 g
5 a
My second table
1
6
5
I want to return:
1 a
1 b
6 f...