mysql how to replace ids with their name value from one table

transaction table

---

id       locationA       locationB
1           2                      3
2           3                      4

---

Location table

---

id          location_name
1                     2
2                     3
3                     4

how to get output like this?

id       locationA       locationB
1        india              china
2        china             america

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2IL7hPr
via IFTTT