New Posts For Thread: Sql help plshttps://community.betfair.com/general_betting/go/thread/view/94082/26179477/sql-help-plsI'm trying to join a match with the names of the two teams. I'm not sure how to do this type of query.ieSelect * from matches,teams where matches.awayTeam= teams.teamId as awayTeamName and matches.homeTeam= teams.teamId as homeTeamNamehmm, but thatsthanks for the help, its sorted now.https://community.betfair.com/general_betting/go/thread/view/94082/26179477/sql-help-pls?post_id=472638701#472638701thanks for the help, its sorted now.Tue, 02 Nov 2010 10:37:28 -0500Try:SELECT ht.TeamName AS HomeTeam, at.TeamName As AwayTeam, m.*FROM Matches mJOIN Teams ht ON ht.TeamId = m.homeTeamJOIN Teams at ON at.TeamId = m.awayTeamhttps://community.betfair.com/general_betting/go/thread/view/94082/26179477/sql-help-pls?post_id=472600869#472600869Try:SELECT ht.TeamName AS HomeTeam, at.TeamName As AwayTeam, m.*FROM Matches mJOIN Teams ht ON ht.TeamId = m.homeTeamJOIN Teams at ON at.TeamId = m.awayTeamTue, 02 Nov 2010 02:13:22 -0500You need to introduce two table aliases for the team tables:SELECT *FROM matches, teams AS t1, teams AS t2WHERE matches.awayTeam = t1.teamId AND matches.homeTeam = t2.teamIdhttps://community.betfair.com/general_betting/go/thread/view/94082/26179477/sql-help-pls?post_id=472600013#472600013You need to introduce two table aliases for the team tables:SELECT *FROM matches, teams AS t1, teams AS t2WHERE matches.awayTeam = t1.teamId AND matches.homeTeam = t2.teamIdTue, 02 Nov 2010 01:49:01 -0500I'm kinda rusty at this stuff, but one way is to use a view.You'll have to look up the correct syntax.Create view myview as Select * from matches,teams where matches.awayTeam= teams.teamId as awayTeamName Select * from myview, teamswhere myview.homeThttps://community.betfair.com/general_betting/go/thread/view/94082/26179477/sql-help-pls?post_id=472599721#472599721I'm kinda rusty at this stuff, but one way is to use a view.You'll have to look up the correct syntax.Create view myview as Select * from matches,teams where matches.awayTeam= teams.teamId as awayTeamName Select * from myview, teamswhere myview.homeTTue, 02 Nov 2010 01:41:15 -0500I'm trying to join a match with the names of the two teams. I'm not sure how to do this type of query.ieSelect * from matches,teams where matches.awayTeam= teams.teamId as awayTeamName and matches.homeTeam= teams.teamId as homeTeamNamehmm, but thatshttps://community.betfair.com/general_betting/go/thread/view/94082/26179477/sql-help-pls?post_id=472594993#472594993I'm trying to join a match with the names of the two teams. I'm not sure how to do this type of query.ieSelect * from matches,teams where matches.awayTeam= teams.teamId as awayTeamName and matches.homeTeam= teams.teamId as homeTeamNamehmm, but thatsMon, 01 Nov 2010 23:49:20 -0500