外部クエリ

外側のクエリ

SELECT * FROM A WHERE id = (SELECT * from B WHERE age > 10);