How do you join 3 tables into r, all data?, or selective.

Question

I can join, historic_runners, and historic_races when being selective on which columns I want but I’m struggling adding the historic_runners_insights data, is there a fast way of selecting all column data from this? With a date condition

Answer 1

Hi -  in terms of adding historic_runners_insights to queries on the other tables, this is covered niicely with examples in Steve Tilley's latest blog post.  Steve then goes on to analyse the variables in R, but if you look at the R code at the end of the post you'll see all the code including the SQL used to extract the code which I think is what you're after?   

See:

https://blog.betwise.net/2020/08/23/looking-at-the-importance-of-variables/

Please accept the answer or follow up with comments if needed.