Excel Query Using VBA & SQL Server Database

Got a simple request as follows

I have a SQL Svr DB containing the follwoing fields:

RACEID
DATE OF RACE
NAME OF GREYHOUND
RESULT
ODDS

I have a spreadsheet where it gives all the possible pairs of runners (30 rows of 2 selections)

I need you to write a query that builds a head to head result summary for all 30 combinations of dogs WHERE they have raced against each other before, which can be found by them both belonging to the same RACEID in the DB

So runner 1 versus runner 2 thru to 6 only where they have the same RACE ID obviously
Then runner 2 versus runner 1 thru to 6 only where they have the same RACE ID obviously
Then runner 3 versus runner 1 thru to 6 only where they have the same RACE ID obviously
and so on

Where 2 Greyhounds have raced before against each other (same Race ID) I need to write back the values of:

RACEID
DATE OF RACE
RESULT
ODDS

for each of the pair of Greyhounds who have raced against each other.

I have attached the spreadsheet showing Race, Dog1 (col B), Dog 2 (col C)

There are multiple sheets (1 race per sheet)


Is this something you could do for me.