New posts in Subquery Factoring

How do you use the "WITH" clause in MySQL?