I have two tables:

* States (AZ, CA, WA, the like)
* Something similar to states, except all char(3) IDs

I need a table that needs to reference both of these with a Foreign Key in another table where either can be a valid input.  

How can I do this? Or is there a better practice for doing something like this?

My current method is just storing a vChar of up to 3 and then searching a View of the two other tables.

"this question is less about the "union" keyword and more about how to have a foreign key on a column that points to TWO tables. Something that's not possible. So, OP wants to know what is the best practice for doing something "like" this."  

As aquinas said, this is exactly correct.

**More on what I'm trying to do**  

Since I can't figure out how to format a table here's an example of what I want to do with the data:

```
        Table 1
------------------------
StateCodes  Desc 
------------------------
 AZ         Arizona
 CA         California
 NY         New York 
 etc        etc

        Table 2
------------------------
 Char3Codes  Desc 
------------------------
 JUR        Jurusalem
 ABP        A Black Panda
 QRM        QR Monument 
 etc        etc

        Table 3
------------------------
 ComboColumn No Desc Column
------------------------
    AZ         
    CA        
    NY        
   JUR
   ABP
   QRM

```

Then with Table3 I should be able to quickly get the Description from the original two tables.