
Author: Maria Alcaraz
Former Freelance Database Developer, Mother of 4 children
FROM: A Clause with Plenty of Possibilities

Think that FROM only specifies tables in an SQL statement? Think again …
When I first began to work with SQL, I saw the FROM clause as the simplest part of any query. You’d put only one table there, or may be two or more tables in the case of a join. That was all I thought about the FROM clause in those days.
As I began to learn more about SQL, I discovered that there are a lot of techniques that can be used in a FROM.