Lookup queries 
are used to query tables for converting database values to human readable values. For example a value can be assigned to the severity of a collision 1, 2, or 3. A look up query can query a table that converts these values to into "Property damage only", "Injury" or "Fatality".