Blog · Guide
SQL FROM Explained: Which Table Are You Asking?
FROM tells the database which table to read. Miss it and you get confusing errors — here’s the mental model.
FROM is the subject of the sentence
If SELECT is “what do you want,” FROM is “talking about what.” Without FROM, the database doesn’t know where first_name lives — and you’ll see errors that sound like “no such column” even when the column exists on a table you forgot to name.
SELECT * FROM customers;
One table first, JOINs later
Beginners should master single-table FROM before JOINs. Same shop dataset: start with customers or products, then learn to connect tables when one table isn’t enough.
Try it yourself
The fastest way to lock this in is a short drill on the same Northstar Market tables.