sql replace id with name in same table 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