SQL #1066 -表/别名不唯一：

Question

我的代码出现以下错误：

SELECT flatpack_ig,FlatpackID ,Name,Colour,Type,UnitPrice,component_ig,ComponentNo, component_ig,
description FROM flatpack_ig
INNER JOIN flatpackcomponent_ig
ON flatpack_ig, FlatpackID= flatpackcomponent_ig,FlatpackID
INNER JOIN component_ig
ON flatpackcomponent_ig, ComponentNo=component_ig,ComponentNo
ORDER BY flatpack_ig,FlatpackID

Answer 1

只要查询中有多个表，就应该始终限定所有列名。如下所示：

SELECT fp.FlatpackID, fp.Name, fp.Colour, fp.Type, fp.UnitPrice,
       c.ComponentNo, c.description
FROM flatpack_ig fp INNER JOIN
     flatpackcomponent_ig fpc
     ON fp.FlatpackID = fpc.FlatpackID INNER JOIN 
     component_ig c INNER JOIN
     flatpackcomponent_ig fpc 
     ON fpc.ComponentNo = c.ComponentNo
ORDER BY fp.FlatpackID;

我在猜测这些列从何而来。我的猜测可能不准确。

您的查询还存在多个其他问题。我猜这些是抄写错误--逗号而不是句点和错误的关键字。

Answer 2

我想我找到了解决方案不确定

SELECT flatpack_ig.FlatpackID，Name，Colour，Type，UnitPrice，component_ig.ComponentNo，component_ig.Description FROM flatpack_ig INNER JOIN flatpackcomponent_ig ON flatpack_ig.FlatpackID= flatpackcomponent_ig.FlatpackID INNER JOIN component_ig ON flatpack_ig.FlatpackID=