mysql - 解析查询时出错

Question

我需要帮助....我不擅长 SQL 我在尝试应用 JOIN 时遇到此错误:

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

这是我的 SQL:

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

团队表有 PK:TeamId夹具表有 FK:HomeTeam我正在使用 WebMatrix 2。Razor 网页

Answer 1

行连接之间没有空格。更改每一行以在末尾包含空格。

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