Where the row from the main query is referenced inside a subquery, like this: ``` SELECT * FROM table1 a WHERE NOT EXISTS (SELECT * FROM table2 WHERE a.id = table_1_id) ```