Inline queries - do more with the FROM clause
Table names aren't the only thing that can come after FROM. You can use entire queries, as described on JustinSomnia.org's great SQL tips and tricks page. His example: "
"
select *from (select sal as salary, comm as commission from emp) xwhere salary < 5000;