G
Guest
I have a table consisting of letters and the state that letter represents.
Now I'm trying to build a query that brings in this table but I keep getting
double the data because it sees a letter twice and brings in the two states
it recognizes it as.
Example. My table would read (a = TX and A = CA) when I run my query it
reads both A's and brings in the capitalized "A" and lowercase "a" together
with the states. How do I distinguish the two and only bring in the lowercase
letters with their respected states?
Now I'm trying to build a query that brings in this table but I keep getting
double the data because it sees a letter twice and brings in the two states
it recognizes it as.
Example. My table would read (a = TX and A = CA) when I run my query it
reads both A's and brings in the capitalized "A" and lowercase "a" together
with the states. How do I distinguish the two and only bring in the lowercase
letters with their respected states?