Learn Inner Join by Pseudocode

inner_join.txt

String sql = "SELECT u.id, u.nama, a.id, a.nama FROM user AS u INNER JOIN user_achievement AS i ON u.id = i.user_id INNER JOIN achievement AS a ON i.achievement_id = a.id";
MysqlDataReader result = ReadData(sql);
List<UserAchievement> listUserAchievement = new List<UserAchievement>()
while(result == true)
{ 
  User user = new User();
  user.id = result[0].getStringData();
  user.nama= result[1].getStringData();
  
  Achievement achievement = new Achievement();
  achievement.id = result[2].getStringData();
  achievement.nama = result[3].getStringData();
  
  UserAchievement userachievement = new UserAchievement();
  userachievement.user = user;
  userachievement.achievement = achievement;
  
  listUserAchievement.add(userachievement);
}
while(result == true)
{ 
  listBoxInfo.items.add(result[1].getStringData() + " memiliki achievement " + result[3].getStringData());
}