Are Values in Query?

I have a query that populates a large some of individuals as well as their respective transactions (each of which is tagged with a type code)

For Example
Name: Code:
John 1
Joe 34
James 1
John 2
John 1
John 37
Joe 2

I also have a table with all of the codes and their descriptions:
Code Desc
1 Food
34 Apples
6 Candy
2 Franks
37 Burgers

The query generates over 60,000 rows. What I am looking to do is see which of the codes in the table appear in the query when it is run.
Code Desc Y/N
1 Food x
34 Apples x
6 Candy
2 Franks x
37 Burgers x

It doesn't necessarly have to be a solution tagging them I just cant figure out how to do this.