SELECT
O.OrderID,
O.ProductID,
O.UnitPrice,
O.Quantity,
O.Discount,
O.ProductName
FROM OrderDetails O
Left Join Products P ON O.ProductID = P.ProductID
SELECT COUNT(*) FROM OrderDetails
SELECT COUNT(*) FROM Products
SELECT TOP 1 OrderID FROM OrderDetails
SELECT TOP 1 ProductID FROM OrderDetails
SELECT TOP 1 UnitPrice FROM OrderDetails
SELECT TOP 1 Quantity FROM OrderDetails
SELECT TOP 1 Discount FROM OrderDetails
SELECT TOP 1 ProductName FROM OrderDetails
SELECT TOP 1 ProductID FROM Products
There was an extra comma after the last field that I removed. I also added aliases to make it easier to read.
SELECT
O.OrderID,
O.ProductID,
O.UnitPrice,
O.Quantity,
O.Discount,
O.ProductName
FROM OrderDetails O
Left Join Products P ON O.ProductID = P.ProductID
You can also run the following code statements one by one to see if you get an error when running any. This will help to troubleshoot if all columns and tables exist. Also make sure that you're connected to the correct database.
SELECT COUNT(*) FROM OrderDetails
SELECT COUNT(*) FROM Products
SELECT TOP 1 OrderID FROM OrderDetails
SELECT TOP 1 ProductID FROM OrderDetails
SELECT TOP 1 UnitPrice FROM OrderDetails
SELECT TOP 1 Quantity FROM OrderDetails
SELECT TOP 1 Discount FROM OrderDetails
SELECT TOP 1 ProductName FROM OrderDetails
SELECT TOP 1 ProductID FROM Products
发布评论
评论（1）
我删除了最后一个字段之后，还有一个额外的逗号。我还添加了别名以使其更容易阅读。
您还可以一一运行以下代码语句，以查看运行时是否会出现错误。如果所有列和表都存在，这将有助于解决问题。还要确保您连接到正确的数据库。
There was an extra comma after the last field that I removed. I also added aliases to make it easier to read.
You can also run the following code statements one by one to see if you get an error when running any. This will help to troubleshoot if all columns and tables exist. Also make sure that you're connected to the correct database.