Unanswered: Substitute value of one field with value from another one ?
If I have a Table 1 with these fields:
Name | Surname | Function
Joe | Blow | 430
...and Table 2 with two fields, first one having IDs of Table 1's "Function" field and second one with their description:
ID | Description
430 | IT manager
How would I do queries on Table 1 to pull out description from Table 2 instead of ID value of "Function" field in Table 1 ? In other words, I need to substitute ID codes from Table 1 with Descriptions from Table 2, making a kind of relational queries.
I know there's a way of using query inside another query, but have no idea how to get current record's field and pull other table's substitution instead of it, all in one query.