Tuple Variables

1. Tuple variables can be used in SQL, and are defined in the from clause:

   

2. These variables can then be used throughout the expression. Think of it as being something like the rename operator.

   

   Finds all customers who have an account at some branch where Jones has an account.