A subquery based on the same tables as the parent query (that is, references columns in the tables included in its parent query).
Copyright © 1984, 2005, Oracle. All rights reserved.