当前位置：文江博客话题详情

使用一个表中的数据从另一个表中获取数据

发布于 2025-01-09 03:21:30 字数 506 浏览 0 评论 0原文

我有点困惑。我为此使用 SSMS。

“对于客户 Ryan Goff 的每次预订，请列出预订 ID、行程 ID 和人数。”

Ryan Goff 位于主键为 CUSTOMER_NUM 的 CUSTOMER 表中。所有其他都在 RESERVATION 表中，主键是 RESERVATION_ID，外键是 CUSTOMER_NUM

我如何仅从姓名中获取预订 ID、行程 ID 和人数的列表？我是否还需要获取人员 CUSTOMER_NUM 才能连接这些值？我该怎么做呢？

粗体 = 主键

CUSTOMER(CUSTOMER_NUM, LAST_NAME, ADDRESS, CITY, STATE, POSTAL_CODE, PHONE)

预订(RESERVATION_ID, TRIP_ID, TRIP_DATE, NUM_PERSONS 、TRIP_PRICE、OTHER_FEES、CUSTOMER_NUM)

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

梦幻的心爱 2025-01-16 03:21:30

您可以将 IN 运算符与子查询结合使用来执行此操作。

这个确切问题的一个例子是：

SELECT RESERVATION_ID, TRIP_ID, NUM_PERSONS
FROM RESERVATION
WHERE CUSTOMER_NUM IN
(SELECT CUSTOMER_NUM
    FROM CUSTOMER
    WHERE FIRST_NAME = 'RYAN' AND LAST_NAME = 'Goff');

You can use the IN operator with a subquery to do this.

An example for this exact question would be:

SELECT RESERVATION_ID, TRIP_ID, NUM_PERSONS
FROM RESERVATION
WHERE CUSTOMER_NUM IN
(SELECT CUSTOMER_NUM
    FROM CUSTOMER
    WHERE FIRST_NAME = 'RYAN' AND LAST_NAME = 'Goff');

回复收藏 0 原文

长途伴 2025-01-16 03:21:30

实现此目的的最佳方法是通过外键连接表，该外键将是客户表中的主键。见下文：

SELECT RESERVATION_ID, TRIP_ID, NUM_PERSONS
FROM RESERVATION
INNER JOIN CUSTOMER NUM
ON RESERVATION.CUSTOMER_NUM = CUSTOMER.CUSTOMER_NUM
WHERE CUSTOMER.FIRST_NAME = 'Ryan' AND CUSTOMER.LAST_NAME = 'Goff'

The best way to achieve this is by joining the tables on the foreign key which would be the primary key in the customer table. See below:

SELECT RESERVATION_ID, TRIP_ID, NUM_PERSONS
FROM RESERVATION
INNER JOIN CUSTOMER NUM
ON RESERVATION.CUSTOMER_NUM = CUSTOMER.CUSTOMER_NUM
WHERE CUSTOMER.FIRST_NAME = 'Ryan' AND CUSTOMER.LAST_NAME = 'Goff'

回复收藏 0 原文

~没有更多了~