I have a table with staff data, containing the usual id, name, address,
etc. Moreover there are some fields (e.g. for nationality, rel.
denomination, title, function) which hold integer or two-character indices
rather than the actual value. The actual values are contained in separate
tables. I do this for ease and safety of input checking in php. If the
data of a particular staff member is to be reported, I would like to have
a single query for the whole row, including the referenced values instead
of the indices itself.
table staff(staff_id, staff_name, staff_title, staff_nat,
entry: (23, ...