Skip to content
Advertisement

How to show data that’s not in a table. SQL ORACLE

I’ve a data base with two tables.

I need a SQL query which show “The players who have not won any game”. I tried but I don’t know even how to begin. Thank you

Advertisement

Answer

You need all the rows from players that don’t have corresponding rows in wins. For this you need a left join, filtering for rows that don’t join:

You can also use not in:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement