SQL Server 教科书中的示例查询出现错误消息,“Ambiguous column name 'V_CODE'" [duplicate]

oxcyiej7 于 2022-12-10 发布在其他

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

This question already has answers here:

SQL column reference "id" is ambiguous (5 answers)
Closed 5 days ago.
For my homework, I have to enter example queries from the book to sql. There are also example database I downloaded for the homework and properly put them into SQL. The following is what I have to put in but an error message comes up.

SELECT V_CODE, V_NAME, V_STATE, P_CODE, P_DESCRIPT, P_PRICE * P_QOH AS TOTAL
FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE
WHERE V_STATE IN ('TN','KY')
ORDER BY V_STATE, TOTAL DESC;

--Total value of products from Tennessee and Kentucky

Ambiguous column name 'V_CODE'
Not sure how to fix.
I had to put in an example query from the homework but an error message comes up.
"Ambiguous column name 'V_CODE'"

sql-server

来源：https://stackoverflow.com/questions/74681024/example-query-from-my-textbook-is-coming-up-with-an-error-message-ambiguous-co

1条答案

按热度按时间

rsaldnfx1#

您需要选择要从中选择V_CODE的表。在本例中，它取自PRODUCT表。

SELECT P.V_CODE, V_NAME, V_STATE, P_CODE, P_DESCRIPT, P_PRICE * P_QOH AS TOTAL
FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE
WHERE V_STATE IN ('TN','KY')
ORDER BY V_STATE, TOTAL DESC;
--Total value of products from Tennessee and Kentucky

赞(0）回复(0）举报 2022-12-10

我来回答

SQL Server 教科书中的示例查询出现错误消息,“Ambiguous column name 'V_CODE'" [duplicate]

1条答案

相关问题

热门标签

最新问答