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

Taught in

References