"Left Join" not necessary
I don't think left join is necessary, as "not in" already looks up orders without a matching company. Also when joining company table, I used join on multiple f
I don't think left join is necessary, as "not in" already looks up orders without a matching company.
Also when joining company table, I used join on multiple fields instead of "where compnay.name = 'RED' " - faster this way.
```
select name 
from salesperson
where sales_id not in (
                        select orders.sales_id
                        from orders 
                        join company on company.com_id = orders.com_id 
                        and company.name = 'RED'
                        )
```
[]