Make custom query from two table access
Open the query designer for a new query.  
Add the tables you are interested in.
Drag the field number from table1 to table2
Drag the field code from table1 to table2
Right click on each of the lines between the two tables and select join properties
Select option 2





Lastly in the bottom section of the designer select the columns you wish to see in your output