607
unknown
mysql
a year ago
240 B
7
Indexable
SELECT s.name FROM SalesPerson s WHERE s.sales_id NOT IN (SELECT o.sales_id FROM Company c JOIN Orders o ON c.com_id = o.com_id AND c.name = 'RED')
Editor is loading...
Leave a Comment
SELECT s.name FROM SalesPerson s WHERE s.sales_id NOT IN (SELECT o.sales_id FROM Company c JOIN Orders o ON c.com_id = o.com_id AND c.name = 'RED')