使用子查询获取查询结果的HOw

SELECT column1, column2
FROM table1
WHERE column1 IN (SELECT column1 FROM table2 WHERE condition);

SELECT column1, (SELECT MAX(column2) FROM table2) AS max_value
FROM table1;

SELECT *
FROM (SELECT column1, column2 FROM table1) AS subquery
WHERE subquery.column1 = 'value';

SELECT column1, column2
FROM table1
WHERE EXISTS (SELECT column1 FROM table2 WHERE condition);

SELECT column1, column2
FROM table1 AS outer
WHERE column1 = (SELECT column1 FROM table2 WHERE table2.column2 = outer.column2);