Forum Discussion
swebster
8 years agoFrequent Visitor
Lookup table with no relationship
I have 2 tables, table A has date and cost, table B has date and escalation rate. There are no related id's between teh 2 tables. I want to pull an escalation rate from table B into a column in table A based on matching the date field in table A and B. Then i can multiply the table A cost by the escalation rate and get the current value.
I can't figure it out.
No RepliesBe the first to reply