Hi - See your query with official rating and speed rating added in the comments below.
Essentially, you need to add the database table name first rather than second when trying to select an individual data field that exists in different tables, as in:
>historic_runners.speed_rating
and
>historic_runners.official_rating
Hope this helps
Colin