qualified column name
A column name written with its table or alias in front, such as c.name, so the database knows which table it means.
In more detail
If two joined tables both have a column called id and you write just id, the database stops with an ambiguous column name error rather than guess. Qualifying every column in a join is a habit worth keeping.
Related terms
- table alias — A short name given to a table inside one query, such as c for customers, used to qualify its columns.
- join — Combining rows from two tables into one result by pairing rows according to a rule, usually matching keys.
Taught in
- Inner Joins And Table Aliases — PostgreSQL, Indexing & Relational Data Modeling