607

Anonymous
mysql
01/27/2024 9:31 PM
320 B
26
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