vendredi 25 mai 2018

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



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire