select s.name
from SalesPerson s
where s.sales_id not in(
select o.sales_id
from orders o left join company c on o.com_id=c.com_id
where
c.name='RED');
刷题日记一、题目二、题解1.SQL语句2.解析总结一、题目二、题解1.SQL语句代码如下(示例):select s.namefrom SalesPerson swhere s.sales_id not in( select o.sales_id from orders o left join company c on o.com_id=c.com_id where c.name='RED');2.解析总结1.使用左连接和子连接..