SQL
The FROM Clause
FROM is the clause in an SQL query that names the table to search. It comes after the fields you list in SELECT and tells the database which table holds the records and fields you want.
The table name after FROM must match the name in the database exactly, so copy it straight from the table rather than typing it from memory. The database looks the table up by that name, so Tbl_Club_Members is not the same as TblClubMembers or Tbl_Club_Member: leaving out the underscores or a letter means no table has that name, so the query fails.
| Table in the database | FROM written as | Correct? |
|---|---|---|
Tbl_Club_Members | FROM Tbl_Club_Members | Yes — exact match |
Tbl_Club_Members | FROM TblClubMembers | No — underscores missing |
Tbl_Club_Members | FROM Tbl_Club_Member | No — final s missing |
Tbl_Club_Members | FROM Tbl_Club_Members, Tbl_Clubs | No — two tables given |
One table per query
Your queries search one table only, so you write a single table name after FROM. You do not need to join tables, and you must not add a comma or a second table name. The query SELECT FullName, MembershipType FROM Tbl_Club_Members WHERE JoinYear = 2025 searches only the club members table. FROM does not decide which records come back — that is the job of the WHERE condition — it only says which table to look in.