Requete

je veux faire une requête pour ajouter une formation mais j'arrive pas a construire une jointure

public class OperationFormation {
  
 
private ArrayList<Formation> Formations =new ArrayList<Formation>();

  public ArrayList<Formation> getFormations() {
      return Formations;
  }

  public void setFormations(ArrayList<Formation> Formations) {
      this.Formations = Formations;
  }
         
 public void add(Formation f){
        
   try {
      Class.forName("com.mysql.jdbc.Driver");
      Connection cn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bdd","root","");
      PreparedStatement pr = cn.prepareStatement("(SELECT id_spec.formation,id_spec.sepcialite From formation,specialite WHERE id_spec.formation =id_spec.specialite)AND INSERT INTO  formation(id_forma,domaine_forma,type_forma,id_spec)VALUES(NULL,?,?,?)");
      pr.executeQuery();
     
      pr.setString(1, f.getDomaine_forma());
      pr.setString(2,f.getType_forma());
      pr.setString(3, f.getId_spec());
    
     pr.execute();
            
   } //  Etudiants.add(e);
    catch (Exception ex) {
      ex.printStackTrace();
   }

 }