执行使用俩个表的select语句

最新推荐文章于 2022-08-04 19:37:57 发布

vanglev

最新推荐文章于 2022-08-04 19:37:57 发布

阅读量362

点赞数

文章标签：产品 video types sql null

本文链接：https://blog.csdn.net/vanglev/article/details/7465324

版权

SQL> select*

2 from product_types;

PRODUCT_TYPE_ID NAME
--------------- ----------
1 Book
2 Video
3 DVD
4 CD

5 Magazine

SQL> select *

2 from products;

PRODUCT_ID PRODUCT_TYPE_ID NAME
---------- --------------- ------------------------------
DESCRIPTION PRICE
-------------------------------------------------- ----------
1 1 Modern Science

A description of modern science 19.95

2 1 Chemistry

Introduction to Chemistry 30

3 2 Supernova

A star explodes 25.99

PRODUCT_ID PRODUCT_TYPE_ID NAME
---------- --------------- ------------------------------
DESCRIPTION PRICE
-------------------------------------------------- ----------
4 2 Tank War

Action movie about a future war 13.95

5 2 Z Files

Series on mysterious activities 49.99

6 2 2412: The Return

Aliens return 14.95

PRODUCT_ID PRODUCT_TYPE_ID NAME
---------- --------------- ------------------------------
DESCRIPTION PRICE
-------------------------------------------------- ----------
7 3 Space Force 9
Adventures of heroes 13.49

8 3 From Another Planet
Alien from another planet lands on Earth 12.99

9 4 Classical Music

The best classical music 10.99

PRODUCT_ID PRODUCT_TYPE_ID NAME
---------- --------------- ------------------------------
DESCRIPTION PRICE
-------------------------------------------------- ----------
10 4 Pop 3
The best popular music 15.99

11 4 Creative Yell
Debut album 14.99

12 My Front Line
Their greatest hits 13.49
*************************************************************************
获得产品#3的名称及其产品类型的名称：
SQL> select products.name,product_types.name
2 from products,product_types
3 where products.product_type_id=product_types.product_type_id
4 and products.product_id=3;

NAME NAME
------------------------------ ----------
Supernova Video
*************************************************************************
查询所有产品的名称和产品类型名并排名，注意上面输出没有名为my front line产品，这个产
品的的product_type_id是null，由于这一点，输出结果没有这一行。以后将介绍如何包含这一
行
SQL> select products.name,product_types.name
2 from products,product_types
3 where products.product_type_id=product_types.product_type_id

4 order by products.name;

NAME NAME
------------------------------ ----------
2412: The Return Video
Chemistry Book
Classical Music CD
Creative Yell CD
From Another Planet DVD
Modern Science Book
Pop 3 CD
Space Force 9 DVD
Supernova Video
Tank War Video
Z Files Video

已选择11行。