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.

customers first_name last_name city result first_name · city
SELECT chooses which columns appear in the result.

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.

Practice reading a table

Related guides