The **EXISTS** operator is a logical operator which returns **TRUE** if there is at least one element in the query and **FALSE** in another case. The next query returns all albums after 2008 first, and if at least such an album exists, retrieves **all the songs**:

SELECT title FROM songs
WHERE EXISTS
  (SELECT id FROM albums
  WHERE year > 2008)

We can also use `NOT EXISTS`. This operator can be used as an additional logical condition after the **WHERE** statement.

If you're an expert in creating queries for a single table, improve your knowledge! Let's start accessing and manipulating two and more tables. During the course, you'll learn how to work with special statements, what is the join and how to use it, and also will practice a lot!

We shall take a look at the database we'll work with and how we can create a query inside another query.

Learn how to join and work with multiple tables.

Try creating queries with no limits on how you should do that. Use all your knowledge from previous chapters!

SQL Exists Statement

SQL Exists Statement