OK I must be missing the point though.

For an upcoming meeting, say Flemington today, how do I get it to query for all the runners running there at once, so that the results returned are the history's of all runners running there today?

Because if I have all my records of all horses etc in the race database and run that query you sent me, won't that just return me all records of all horses in the DB?

Sorry if this is a nuisance.