与:(获取错误“错误代码:1052。字段列表中的列“ INV_NUMBER”不明确”)
SELECT CONCAT(CUS_FNAME, " " ,CUS_LNAME) AS 'Customer',
INV_NUMBER AS 'inv_number',
DATE_FORMAT(invoice.INV_DATE, '%W') AS 'Day of Week'
SUM(line.LINE_PRICE)
FROM customer
RIGHT JOIN INVOICE ON invoice.CUS_CODE = customer.CUS_CODE
JOIN LINE
WHERE CUS_FNAME LIKE 'Leona%'
OR CUS_FNAME LIKE '%Paul%'
OR CUS_FNAME LIKE '%Myron%'
GROUP BY INV_NUMBER;
与此相反:
与:
SELECT CONCAT(CUS_FNAME, " " ,CUS_LNAME) AS 'Customer',
INV_NUMBER AS 'inv_number',
DATE_FORMAT(invoice.INV_DATE, '%W') AS 'Day of Week'
FROM customer
RIGHT JOIN INVOICE ON invoice.CUS_CODE = customer.CUS_CODE
WHERE CUS_FNAME LIKE 'Leona%'
OR CUS_FNAME LIKE '%Paul%'
OR CUS_FNAME LIKE '%Myron%'
GROUP BY INV_NUMBER;
这是ERD:
(更好的解释?)我的第二段代码是我在处理问题时想出的一切,直到我在第一段代码中添加了一些语句后,一切都正常了。我正在尝试添加“花了钱”列,但我不断收到错误消息:
错误代码:1052。字段列表中的列“ INV_NUMBER”不明确
您INV_NUMBER
可能来自LINE
或INVOICE
。在您的选择中指定它:
SELECT
`INVOICE`.`INV_NUMBER` AS 'inv_number'
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句