The UNION operator combines the results of multiple queries and removes duplicates. Try:

SELECT title FROM action_movies UNION SELECT title FROM scifi_movies;

Notice which rows belong to both tables, and whether they appear as duplicates in the result (hint: they don't).