Enables you to search a table using iterative self-join and set operations. Multiple definitions of the nonrecursive form can be used with a single SELECT statement by specifying different queries by name.
Note: You can only use this statement modifier with SELECT statements. WITH cannot be used with other DML statements.
where: