I have the tables set up as below (simplified)
BET (BetID, Title, Date, Event, Bookie1, Bookie2)
BOOKIE (BookieName, URL)
Every bet contains (among others) 2 bookies.
Each bookie has an URL.
For every bet I need a command to select all from bet along with the URL of both the bookies that are involved. This is the closest I have got but there is "incorrect sytax near c".
SELECT a.*, b.url as 'url1', d.url as 'url2'
FROM (BookieBet a INNER JOIN Bookies b on a.Bookie1 = b.BookieName) c INNER JOIN Bookie d on c.Bookie2 = d.BookieName
Any help appreciated.