subqueries

Question

subqueries can be from another table or must be in the same table ?

Answer 1

Yes, they can be from another table. See example.

SELECT column-names
FROM table-name1
WHERE value IN (SELECT column-name
FROM table-name2
WHERE condition)