hi, i have 2 sets of data (2 tables) and i want to know how to do a query where i can match the two?


basically this is what i want to do (i know its probably very easy but i am a novice so bare with me)

i want to take both tables..

do a look up query, to filter out data , basically i want it to look at this one table (a third table that will have certain data) then go back and pull anything that matches that table from the other two and create a new table with the results

example

table one contains orders ABC and table to contains orders DEF , well in the look up table there are orders EBA, so when i run the query i want it to look up table 3 and anything thats in there (in this case EBA) return it from the other two tables in a new table

god this is confusing, im sure this is VERY simple im just over explaining.