sql replace id with name code example
Example: sql replace id with name from another table
The answer of sagi did not really work correctly.
I've found a much simpler and working solution in another thread:
SQL Replace multiple variables from another table in query result