SQL & PL/SQL

Hi,

Under Oracle 19c, in a statement I want to add the value ID (primary key) of the table GL_INDIVIDU in the field RESS_IDIND of the table GL_TD_RESSEA, but the value is from another table than the table GL_TD_DECOUVERTE_RESA. This is working for the same table but I don't know how to pass the value of 2 tables.

insert into GL_TD_RESSEA (RESS_SEAID, RESS_CREAPAR)
select ID, RESAD_CREAPAR from GL_TD_DECOUVERTE_RESA  where UPPER(resad_PNOM) = UPPER(:P24_PRENOM_DU_DEMANDEUR) AND UPPER(RESAD_NOM) = UPPER(:P24_NOM_DU_DEMANDEUR);

CREATE TABLE "GL_TD_RESSEA" 
  (    "ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
    "N_" NUMBER, 
    "RESS_SEAID" VARCHAR2(50), 
    "RESS_IDIND" VARCHAR2(50), 
    "RESS_IDORG" VARCHAR2(50), 
    "RESS_ORGADULT" NUMBER, 
    "RESS_ORGENF" NUMBER, 
    "RESS_ORGAGE" VARCHAR2(50), 
    "RESS_PRES" NUMBER, 
    "RESS_PORGADULT" NUMBER, 
    "RESS_PORGENF" NUMBER, 
    "RESS_SEXE" VARCHAR2(32767), 
    "RESS_DANNUL" VARCHAR2(50), 
    "RESS_COMMENT" VARCHAR2(32767), 
    "RESS_DCREA" VARCHAR2(50), 
    "RESS_CREAPAR" VARCHAR2(50), 
    "RESS_DMODIF" VARCHAR2(50), 
    "RESS_MODIFPAR" VARCHAR2(50), 
     PRIMARY KEY ("ID")
 USING INDEX  ENABLE
  )

CREATE TABLE "GL_TD_DECOUVERTE_RESA" 
  (    "ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
    "RESAD_ID" NUMBER, 
    "RESAD_PNOM" VARCHAR2(50), 
    "RESAD_NOM" VARCHAR2(50), 
    "RESAD_ADR" VARCHAR2(255), 
    "RESAD_ADR1" VARCHAR2(50), 
    "RESAD_CP" NUMBER, 
    "RESAD_VILLE" VARCHAR2(50), 
    "RESAD_MOBIL" VARCHAR2(50), 
    "RESAD_MAIL" VARCHAR2(255), 
    "RESAD_NN" NUMBER, 
    "RESAD_DOB" VARCHAR2(50), 
    "RESAD_SEAID" VARCHAR2(50), 
    "RESAD_PART" NUMBER, 
    "RESAD_DCREA" DATE DEFAULT SYSDATE, 
    "RESAD_CREAPAR" VARCHAR2(50), 
    "RESAD_DMODIF" DATE DEFAULT SYSDATE, 
    "RESAD_MODIFPAR" VARCHAR2(50), 
     PRIMARY KEY ("ID")
 USING INDEX  ENABLE
  ) ;

Thank you.