代码之家  ›  专栏  ›  技术社区  ›  Developer Tanbir

SQL语法错误:多重联接错误

  •  -1
  • Developer Tanbir  · 技术社区  · 7 年前

    我使用了多个联接表。但我有一个错误。我不明白。这是我的密码。

    `SELECT cities.cities, address.village, address.phone
    
    

    FROM tbl_join INSERT JOIN cities ON tbl_join.id = cities.id INSERT JOIN address ON tbl_join.id = address.id`

    显示这个错误
    `Error
    
    SQL query: Documentation
    
    SELECT cities.cities, address.village, address.phone
    
    FROM tbl_join
    INSERT JOIN cities ON tbl_join.id = cities.id
    INSERT JOIN address ON tbl_join.id = address.id LIMIT 0, 25
    
    MySQL said: Documentation
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INSERT JOIN cities ON tbl_join.id = cities.id
    INSERT JOIN address ON tbl_join.i' at line 4`
    1 回复  |  直到 7 年前
        1
  •  1
  •   Muhammad Waheed Ray K.    7 年前

    它的 INNER JOIN 不 INSERT JOIN