Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Retrieve value from another table based on a date

Hi,   I have 2 tables.   In table 1 (hours) I have a row with a hour_date column and an card_id column In table 2 (salaries) I have a row with a start_date column, end_date column, salary_rate a...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    try to add a column in this way:

     

     

     

     

     

     

    I still have some doubts as to whether the start_date information from the salary table is not used.

     

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

If Rocco_sprmnt21's answer sloves your problem , could you kindly accept it as a solution to close this case and help the other members find it more quickly?
If not, please feel free to let me know.
 
Best Regards
Maggie
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Thanks for the provided solution, I will test it soon and will accept it when it's proven it worked. Will get back to it asap