There are two tables: students, and scores, in the mysql database （4.0＋) exactly like t-学而优知识库

There are two tables: students, and scores, in the mysql database （4.0＋) exactly like t

There are two tables: students, and scores, in the mysql database (4.0+) exactly like this:
SN | Name SN | Score
------------- -------------
1 | Jerry 1 | 48
------------- -------------
2 | Lily 2 | 50
------------- -------------
3 | Roy
-------------
where the SN is the foreigh key. Write an SQL statement to delete all the names that have no score.

参考答案

查看答案