这个INNER JOIN
关键字选择在两个表中具有匹配值的记录。
让我们看一个使用我们的虚拟对象的例子testproducts
表格:
testproduct_id | product_name | category_id
----------------+------------------------+-------------
1 | Johns Fruit Cake | 3
2 | Marys Healthy Mix | 9
3 | Peters Scary Stuff | 10
4 | Jims Secret Recipe | 11
5 | Elisabeths Best Apples | 12
6 | Janes Favorite Cheese | 4
7 | Billys Home Made Pizza | 13
8 | Ellas Special Salmon | 8
9 | Roberts Rich Spaghetti | 5
10 | Mias Popular Ice | 14
(10 rows)
我们将努力加入testproducts
表与categories
表格:
category_id | category_name | description
-------------+----------------+------------------------------------------------------------
1 | Beverages | Soft drinks, coffees, teas, beers, and ales
2 | Condiments | Sweet and savory sauces, relishes, spreads, and seasonings
3 | Confections | Desserts, candies, and sweet breads
4 | Dairy Products | Cheeses
5 | Grains/Cereals | Breads, crackers, pasta, and cereal
6 | Meat/Poultry | Prepared meats
7 | Produce | Dried fruit and bean curd
8 | Seafood | Seaweed and fish
(8 rows)
请注意,许多产品testproducts
有一个category_id
与中的任何类别都不匹配categories
表格。
通过使用INNER JOIN
我们不会获取不匹配的记录,我们只会获取匹配的记录两个都表:
加入testproducts
到 categories
使用category_id
柱子:
SELECT testproduct_id, product_name, category_name
FROM testproducts
INNER JOIN categories ON testproducts.category_id = categories.category_id;
运行示例 »
仅返回两个表中都匹配的记录:
testproduct_id | product_name | category_name
----------------+------------------------+----------------
1 | Johns Fruit Cake | Confections
6 | Janes Favorite Cheese | Dairy Products
8 | Ellas Special Salmon | Seafood
9 | Roberts Rich Spaghetti | Grains/Cereals
(4 rows)
笔记:JOIN
和INNER JOIN
会给出相同的结果。
INNER
是默认的连接类型JOIN
,所以当你写JOIN
解析器实际上写的是INNER JOIN
。
截取页面反馈部分,让我们更快修复内容!也可以直接跳过填写反馈内容!