title: How can i get a database view which has foreign keys changed in the real value?
body: <p>i'm not so good in programming, and i've to make this fix in my code, which basically has 2 tables (players: ID, name,password ; match: player_ID, attack, level)connected by primary and foreign keys. I've to retrieve an output which contains the player_ID changed with the real player name. I know how it works at db-level, but now i'm using JDBC to interact with the Mysql database. I've understood that i've to manipulate the db-metadata, but i still have not understood with which method and overall the logic behind. </p>