SQL Server | Easy | Using join
\n\nselect name from SalesPerson \nwhere sales_id NOT in \n( select o.sales_id  from Orders o join \nCompany c on c.com_id = o.com_id  and c.name   = \'RED\'\n)
```\n\n```select name from SalesPerson \nwhere sales_id NOT in \n( select o.sales_id  from Orders o join \nCompany c on c.com_id = o.com_id  and c.name   = \'RED\'\n)\n
['MS SQL Server']