I have data on the runners etc. from the 'daily_runners' table using 'race_id'. For example:
Select * from daily_runners
WHERE race_id = '1062243'
This query concerns a race at Wolverhampton on 02-Oct-2021. I have the same for all races on this day.
I want to match 'bsp' and 'win' with the runners on that day by capturing all data from 'historic_betfair_win_prices' using this query:
SELECT date, sf_race_id, sf_runner_id, sf_name, win, bsp
WHERE date = '2021-10-02'
The latter query, however, does not retrieve data corresponding to the 'race_id' or any data for the other races at Wolverhampton.
How can I retrieve this data?
I appreciate any help you can provide.