SELECT pupil.name, pupil.surname, mark_value.values
FROM pupil, mark_value, mark
WHERE pupil.id = mark.pupil_id AND mark.mark_id = mark_value.id

package sqltest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class SQLtest {


    private static final String url = "jdbc:mysql://localhost:3306/school_db?useTimezone=true&serverTimezone=GMT";
    private static final String user = "root";
    private static final String password = "123456";





    private static Connection con;
    private static PreparedStatement stmtGetStudent;

    private static PreparedStatement stmtGetMarks;
    private static ResultSet rs;

    public static void main(String args[]) {
        String query = "SELECT student.id, student.name ,student.surname from student";
        String query1 = "SELECT pupil.name, pupil.surname, mark_value.values
    FROM pupil, mark_value, mark"
    WHERE pupil.id = mark.pupil_id AND mark.mark_id = mark_value.id"
                + " ";

        try {
            con = DriverManager.getConnection(url, user, password);

            stmtGetStudent = con.prepareStatement(query);
            stmtGetMarks = con.prepareStatement(query1);

            //stmtGetMarks.setString(1, "Vasya");
            //stmtGetMarks.setInt(2, 1234);
            // rs = stmtGetMarks.executeQuery();

            rs = stmtGetStudent.executeQuery();

            while (rs.next()) {
                int id = rs.getInt(1);
                String firstName = rs.getString(2);
                String lastName = rs.getString(3);



              System.out.println("Students :  " + firstName + " " + lastName);
            }

        } catch (SQLException sqlEx) {
            sqlEx.printStackTrace();
        } finally {

            try { con.close(); } catch(SQLException se) { }
            try { stmt.close(); } catch(SQLException se) { }
            try { rs.close(); } catch(SQLException se) {  }
        }
    }
}