/SQL/Sql replace id with name from another table

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

Similar codes

0 vote147 views1 answer
Postegresql update to null
SQL
2 votes149 views1 answer
Columns Present in a table
SQL
0 vote140 views3 answers
How to verify sequence result in oracle SQL
SQL
10 votes139 views2 answers
Linux command line import mysql database
SQL
0 vote166 views1 answer
Getting next sequence value jpa postgress
SQL
6 votes145 views2 answers
Mysql get yesterday
SQL
5 votes237 views1 answer
Oracle asynchronous procedure
SQL
0 vote187 views2 answers
How to install psql in ubuntu
SQL
0 vote142 views1 answer
Use where instead of join
SQL
0 vote170 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL