607

 avatar
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