Search code examples
mysqlsqlsql-server-cewebmatrix-2razor-2

There was an error parsing the query

I need help.... I am not good at SQL I get this error when I try to apply a JOIN:

[ Token line number = 1,Token line offset = 66,Token in error = JOIN ]

This is My SQL:

var query = "SELECT Team.TeamName, Fixtures.HomeTeam" +
                "FROM Team" +
                "LEFT JOIN Fixtures" +
                "ON Team.TeamId=Fixtures.HomeTeam" +
                "ORDER BY Team.TeamName";

Team Table Has PK: TeamId Fixture Table Has FK: HomeTeam I am using WebMatrix 2. Razor WebPages

Solution

  • No spaces between line concatenations. Change every line to include space at the end. 

    var query = "SELECT Team.TeamName, Fixtures.HomeTeam " +
            "FROM Team " +
            "LEFT JOIN Fixtures " +
            "ON Team.TeamId=Fixtures.HomeTeam " +
            "ORDER BY Team.TeamName";