1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

SQL Inner Join

Discussion in 'SQL Server' started by coolcalimba, Sep 19, 2007.

  1. coolcalimba

    coolcalimba New Member

    Hello

    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.
    Cheers
     
  2. shabbir

    shabbir Administrator Staff Member

    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
    
     
  3. coolcalimba

    coolcalimba New Member

    Cheers mate, seems I was over complicating things slightly.!
     
  4. shabbir

    shabbir Administrator Staff Member

    Did that SQL work
     

Share This Page