如何同时将A与B以及B与C一起加入? [英] How can I join A with B and also B with C at one time?

问题描述

我有三个A，B，C表.

I have three A, B, C tables.

我如何一次将A与B以及B与C加入?

How can I join A with B and also B with C at one time?

例如，如果我有以下表:订单"，产品"，用户"，我希望像这样的查询:

For example If I have these tables: Order, Product, User, I want be like this query:

SELECT Product.title, User.username, Order.id
FROM Order
/* with this condition: */
Order.ProductID = Product.ID
Product.UserID = User.ID

推荐答案

尝试:

SELECT Product.title, User.username, Order.id
FROM Order
INNER join Product ON Order.ProductID = Product.ID
INNER JOIN user ON Product.UserID = User.ID

这篇关于如何同时将A与B以及B与C一起加入?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！