combining two tables, codes table references multiple records in the second table
Posted on 2009-04-03
Table1 has a column called Codes with values such as:
Table2 has columns which expand these codes, such as:
Code column: USA
Country column: United States
Type column: Country
I need to somehow combine these tables in a way that I can reference the full, expanded names from Table2, as well as the Type column, so they can be added to the Where clause. However, I'm completely lost as to how to do this, so I would really appreciate any help. Thank you!