Newbie question: Why MINUS not working?


  • 0
    P

    I used code like this, but I got a runtime error near line 5. Does anyone know where is wrong? Thanks!

    SELECT Name
    FROM Customers
    MINUS
    SELECT Customers.Name
    FROM Customers, Orders
    WHERE Customers.Id = Orders.CustomerId

  • 1
    S

    because you used the same table ,the way to "Minus" must select different table.


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.