所以我知道如何使用连接创建查询,但是如何将此连接转换为子查询?我一直在尝试各种各样的事情,但我就是想不通。
我的连接如下所示:
SELECT
c.email_address, o.order_id, o.order_date
FROM
customer c
JOIN orders o ON (c.customer_id = o.customer_id)
ORDER BY
order_date;
创建多表的尝试:
SELECT
c.email_address, o.order_id, o.order_date
FROM
customer c
WHERE
c.customer_id IN (SELECT o.customer_id FROM orders o)
ORDER BY
o.order_date;
我总是犯错误 unknown column
两者皆适用 order_id
以及 order_date
暂无答案!
目前还没有任何答案,快来回答吧!