CODE EXAMPLE FOR SQL

subquery in sql

SELECT column_name
 FROM table_name1
WHERE VALUE IN 
(SELECT column_name
FROM table_name2 
WHERE condition)