I am a Junior Developer. I have been asked to create a subquery to solve this problem. If the question is not clear then please let me know so I can provide more details.
I have two tables,
Author. I have been tasked with doing the following:
Select distinct Author values that don't exist in the Author table. The result should not contain any Authors that are NULL or Empty String. The purpose is to find any Author names that ARE in the Article table but NOT in the Author table.
I have Author column in both Tables. Can this problem be solved by joining these two tables?
I have tried
select distinct name from author where name NOT IN ( select author from article where author IS NOT NULL)
It doesn't give me the result that I want :(