Easy SQL Challenge: Using LEFT OUTER JOIN

365 Days of Daily Challenge: Day 64

Today was definitely a lazy day. I basically slept my heart out and recuperated from a busy week. I found a bunch of books lying near the recycle bins. One human’s trash is another’s treasure. I adopted the books and have been reading them. I am just apalled by those people that choose to throw them instead of make good use of them by donating it to some charity or public libraries. Back home, I know some people would cherish these donations.

Today, I completed an easy SQL challenge where I had to revisit the concept of LEFT OUTER JOIN.

SELECT a.first_name, a.last_name
FROM actor_movie a
LEFT OUTER JOIN actor_tv t
ON a.actor_id = t.actor_id
WHERE t.actor_id IS NULL;

Leave a comment