Double Lookup Query

[kcyankees125]

I have a table called say [DATA]. Among many more, there are 2 fields called [ORIGIN] and [DESTINATION] each with a 4 letter alphabet code that represents the location (e.g. ABCD or JEVK). I have another table called [CONVERSION] that has 2 fields:

 with all of the 4 letter alphabet codes and [TYPE] which has a D or I for Domestic or International.  I would like to make ONE query that gives me 2 new fields that convert the CODE to the TYPE --> a [ORIGIN_TYPE] field and a [DESTINATION_TYPE] field.

Is there a way I can do this with an easy Access set up query or basic SQL query?

 

[plog]

Yes there is. Read this tutorial and it should lend some insight:

http://www.1keydata.com/sql/sql.html

 

[kcyankees125]

I'm new to SQL... could you give me some guidance on which functions?

 

[plog]

No functions, it sounds like a simple query. Read up on how to create queries.