Is it possible to perform a JOIN using nested queries in SQL?

Yes, it is possible. A subquery can be used as a data source (table) for a JOIN.

Example:

SELECT t1.column1, sub.column2
FROM table1 AS t1
JOIN (
    SELECT id, column2
    FROM table2
    WHERE condition = 'some_value'
) AS sub ON t1.id = sub.id;

Here, the subquery SELECT id, column2 FROM table2 WHERE condition = 'some_value' returns a result that is then used as a temporary table with the alias sub to perform a JOIN with table1.