编写 SQL 查询以从下表中选择项目

2021-12-12 00:00:00 excel ms-access sql mysql

我很难编写 SELECT 查询来获取下表中的数据...

I am having a really hard time writing a SELECT query to get a hold of the data in the following table...

这是一张桌子的图片...

Here is a picture of the table...

http://i44.tinypic.com/29dxx81.png

我正在尝试为所有数量大于 10 的项目部件显示部件名称 (pname)...但是，数量似乎只有在子菜单展开时才会出现，我在选择时遇到问题正在……

I am trying to display the names of the parts (pname) for all item parts that have a quantity larger than 10... However, the quantity seems to appear only when the submenu is expanded, and I am having trouble SELECT'ing it...

谢谢

推荐答案

您是否尝试过:

SELECT pname from [TableName] WHERE quantity >= 10


SELECT pname from Parts 
INNER JOIN Shipments
ON Parts.ForeignKey = Shipments.ForeignKey
WHERE quantity >= 10

相关文章