M
Mark
Hi, I'm trying to search two tables to find data that correlates with 3
columns (my unique identifier).
In one table, I have 3 columns
City Name, Dest City, Dest State
In another table, I have multiple columns, which include
City Name, Dest City, Dest State & Price
I want to search the 2nd table to find the Price that correlates with the
exact match of City Name + Dest City + Dest State, and return that Price to
me in the first table where an exact match was found.
Example - In the Table with Data
City Name Dest City Dest State Price
Dallas Fac Chicago IL 2.01
Atlanta Fac Houston TX 3.01
Dallas Fac Austin TX 4.01
In the target table, there might be rows with City Name, Dest City & Dest
State that match, and some that don't. For those rows where everything
matches, I want it to pull in the info that correlates it from the original
table like:
City Name Dest City Dest State Price
Dallas Fac Chicago IL 2.01
Dallas Fac Seattle WA
Atlanta Fac Houston TX 3.01
Dallas Fac Austin TX 4.01
Atlanta Fac Abilene TX
Help?
Thanks,
Mark
columns (my unique identifier).
In one table, I have 3 columns
City Name, Dest City, Dest State
In another table, I have multiple columns, which include
City Name, Dest City, Dest State & Price
I want to search the 2nd table to find the Price that correlates with the
exact match of City Name + Dest City + Dest State, and return that Price to
me in the first table where an exact match was found.
Example - In the Table with Data
City Name Dest City Dest State Price
Dallas Fac Chicago IL 2.01
Atlanta Fac Houston TX 3.01
Dallas Fac Austin TX 4.01
In the target table, there might be rows with City Name, Dest City & Dest
State that match, and some that don't. For those rows where everything
matches, I want it to pull in the info that correlates it from the original
table like:
City Name Dest City Dest State Price
Dallas Fac Chicago IL 2.01
Dallas Fac Seattle WA
Atlanta Fac Houston TX 3.01
Dallas Fac Austin TX 4.01
Atlanta Fac Abilene TX
Help?
Thanks,
Mark