I hope i can get some help with this. I have had no luck at all so far..
has fields str_nbr and str_st
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..
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?