607. 销售员

最新推荐文章于 2023-07-07 17:12:34 发布

Blue Faith

最新推荐文章于 2023-07-07 17:12:34 发布

阅读量135

点赞数

文章标签：数据库开发

本文链接：https://blog.youkuaiyun.com/ly17809212771/article/details/124863209

版权

607. 销售员

在这里插入图片描述

方法1：嵌套连接

# Write your MySQL query statement below
select name
from SalesPerson
where sales_id not in (
    select sales_id from orders where com_id in(
        select com_id from company where name='RED'
    )
)

方法2：全连接

# Write your MySQL query statement below
select name
from SalesPerson
where sales_id not in (
    (select sales_id 
    from Orders join Company ON Orders.com_id=Company.com_id
    where Company.name='RED'
    )
)