You are not specifying the table name near C Also I am just giving a try and its not a tested one.

Code:
Select b.*, b1.url, b2.url from BET b, BOOKIE b1, BOOKIE b2
where b1.BookieName = b.Bookie1 AND b2.BookieName = b.Bookie2