Check out example codes for "join to find results not in another table". It will help you in understanding the concepts better.

Code Example 1

SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL

Learn ReactJs, React Native from akashmittal.com