SQL 子查詢

 

子查詢的語法如下：

SELECT "欄位1"
FROM "表格"
WHERE "欄位2" [比較運算素]
(SELECT "欄位1"
FROM "表格"
WHERE [條件])

SQL 子查詢