MYSQL 将两列与一列连接并获取数据

Question

固定的！抱歉浪费了大家的时间 :P

我试图在 PHP 中使用 mysql 将两列与一列连接起来

$result = $link->query('选择软件。*, 
流派.Naam AS 流派， 
Console.Naam AS ConsoleNaam,
Draager.Naam AS MediumNaam,
工作室.Naam AS StudioNaam,
Publisher.Naam AS PublisherNaam
来自软件
INNER JOIN 流派 ON Genre.Genre_ID = Software.Genre_ID
INNER JOIN Console ON Console.Console_ID = Software.Console_ID
内部连接 ​​Draager ON Draager.Draager_ID = Software.Medium_ID
INNER JOIN 公司 AS Studio ON Software.Studio_ID = Studio.Company_ID
INNER JOIN 公司 AS 发布者 ON Software.Publisher_ID = Publisher.Company_ID
'）；

Table Company 必须在 ID 上与 Table Software 合作才能获得 公司名称。

关于我必须对上面的脚本进行哪些更改才能实现的任何提示 工作？

Answer 1

只是为了得到一个答案：

关联表时 JION 拼写为 JOIN :D

$result = $link->query('SELECT Software.*, 
Genre.Naam AS Genre, 
Console.Naam AS ConsoleNaam,
Draager.Naam AS MediumNaam,
Studio.Naam AS StudioNaam,
Publisher.Naam AS PublisherNaam
FROM Software
INNER JOIN Genre ON Genre.Genre_ID = Software.Genre_ID
INNER JOIN Console ON Console.Console_ID = Software.Console_ID
INNER JOIN Draager ON Draager.Draager_ID = Software.Medium_ID
INNER JOIN Company AS Studio ON Software.Studio_ID = Studio.Company_ID
INNER JOIN Company AS Publisher ON Software.Publisher_ID = Publisher.Company_ID
');

Answer 2

你有一个错字。 JOIN 拼写错误为 JION：

$result = $link->query('SELECT Software.*, 
Genre.Naam AS Genre, 
Console.Naam AS ConsoleNaam,
Draager.Naam AS MediumNaam,
Studio.Naam AS StudioNaam,
Publisher.Naam AS PublisherNaam
FROM Software
INNER JOIN Genre ON Genre.Genre_ID = Software.Genre_ID
INNER JOIN Console ON Console.Console_ID = Software.Console_ID
INNER JOIN Draager ON Draager.Draager_ID = Software.Medium_ID
/* Misspelled JOIN below *(/
INNER JOIN Company AS Studio ON Software.Studio_ID = Studio.Company_ID
INNER JOIN Company AS Publisher ON Software.Publisher_ID = Publisher.Company_ID
');