从下表中将SQL查询写入SELECT项 [英] Writing an SQL query to SELECT item from the following table
本文介绍了从下表中将SQL查询写入SELECT项的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我很难写一个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
这篇关于从下表中将SQL查询写入SELECT项的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文