MYSQL错误1060 -重复的列

vbopmzt1 于 2023-11-16 发布在 Mysql

关注(0)|答案(1)|浏览(144)

如何避免错误1060？

CREATE VIEW `new-query` AS

SELECT L1.Inv_Num, L1.Line_Num, P1.Prod_SKU, P1.Prod_Descript,
L2.Line_Num, P2.Prod_SKU, P2.Prod_Descript, P1.Brand_ID

FROM LGLINE L1, LGLINE L2, LGPRODUCT P1, LGPRODUCT P2

WHERE P1.Prod_Category IN ('SEALER') AND P2.Prod_Category IN ('TOP COAT');

字符串

mysql

来源：https://stackoverflow.com/questions/29664840/mysql-error-1060-duplicate-column

1条答案

按热度按时间

zbq4xfa01#

相同的列名被指定了两次，所以需要将列名别名为唯一的名称。我只是将l1_、l2_ p1_和p2_添加到出现多次的列中。

CREATE VIEW new-query AS
SELECT L1.Inv_Num, L1.Line_Num l1_line num, P1.Prod_SKU p1_prod_sku, P1.Prod_Descript p1_prod_descript, L2.Line_Num l2_line num, P2.Prod_SKU p2_prod_sku, P2.Prod_Descript p2_prod_descript, P1.Brand_ID
FROM LGLINE L1, LGLINE L2, LGPRODUCT P1, LGPRODUCT P2
WHERE P1.Prod_Category IN ('SEALER') AND P2.Prod_Category IN ('TOP COAT');

字符串

赞(0）回复(0）举报 2023-11-16

我来回答

MYSQL错误1060 -重复的列

1条答案

相关问题

热门标签

最新问答