About

A lookup table is a table that is also known as:

  • XREF
  • or cross-reference table

A lookup is when a query joins the base table and the lookup table to obtain the values of the lookup table for each row in the base table.