How can I join two tables or realize it through Python?

As far as I know, we can link to another record to connect with another table, but that would be less enough when we want more detailed data or automated them.
For example, I recorded the names for each house, then in another table, I want to list the house names for each person.
I cannot just display the names but select them one by one, which is of low efficiency.

Is there an API to update it though Python?