Author: Maria Alcaraz

Former Freelance Database Developer, Mother of 4 children

FROM: A Clause with Plenty of Possibilities

hands chosing colorful donuts from paper boxes, many options and 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.