Linking Data

joshua.goodman · May 4th, 2015, 10:44 AM

I hope i can get some help with this. I have had no luck at all so far..

Table 1

dbo_str
has fields str_nbr and str_st

table 2

StoreSpecific
has fields Store and State

each of the above tables have more fields but i limited it to the fields in question to simplify

I want State in table 2 to pull from table one based on the store..
i.e.

Code:

SELECT dbo_STR.STR_ST FROM dbo_STR WHERE STORE=dbo_STR.STR_NBR;

Table 1 dbo_STR is a linked table via ODBC
This doesn't work Any idea's?