SQL Subqueries Subqueries in SELECT clause
Example
Subqueries can also be used in the SELECT part of the outer query. The following query
shows all weather table columns with the corresponding states from the cities table.
SELECT w.*, (SELECT c.state FROM cities AS c WHERE c.name = w.city ) AS state
FROM weather AS w;
