Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT date, price/rate AS adjusted FROM
- table1 a JOIN table2 b ON a.date=b.date
- date price
- 2019-01-01 2.3
- 2019-01-03 3.4
- 2019-01-04 2.6
- 2019-01-05 2.2
- 2019-01-06 2.5
- 2019-01-07 5.1
- 2019-01-08 4.6
- 2019-01-09 4.2
- 2019-01-10 3.3
- date rate
- 2019-01-04 1.1
- 2019-01-06 1.3
- 2019-01-09 1.0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement