In a correlated subquery, the WHERE expression in a subquery refers to values in a table in the outer query. The correlated subquery is evaluated for each row in the outer query. With correlated ...

If the query-expression involves more than two table-expressions, the result from the first two becomes an operand for the next set operator and operand, for example, ... For example, when performing ...