SQL & PL/SQL

Hi,

I am developing under APEX 26.1, Oracle 19c.

I want to select all the values “COURRIEL” from the table PA_ADHERENT where the column "JE_SOUHAITE_RECEVOIR_DES_INFORMATIONS_SUR_LES_EVÉNEMENTS_ET_LES_ATELIERS" of the table PA_AUTORISATION contains the value ‘Oui’.

Here are the DDL of the tables:

 CREATE TABLE "PA_AUTORISATION" 
   (	"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, 
	"PRÉNOM" VARCHAR2(96 CHAR) NOT NULL ENABLE, 
	"NOM" VARCHAR2(96 CHAR) NOT NULL ENABLE, 
	"CONSENTEMENT_AU_TRAITEMENT_DONNÉES_PERSONNELLES" VARCHAR2(48 CHAR) NOT NULL ENABLE, 
	"CONSENTEMENT_AU_DROIT_À_IMAGE" VARCHAR2(48 CHAR) NOT NULL ENABLE, 
	"AUTORISATION_DE_DIFFUSION_SUR_LES_RÉSEAUX_SOCIAUX_ET_LE_SITE_INTERNET" VARCHAR2(48 CHAR) NOT NULL ENABLE, 
	"JE_SOUHAITE_RECEVOIR_LA_NEWSLETTER" VARCHAR2(48 CHAR) NOT NULL ENABLE, 
	"JE_SOUHAITE_RECEVOIR_DES_INFORMATIONS_SUR_LES_EVÉNEMENTS_ET_LES_ATELIERS" VARCHAR2(48 CHAR) NOT NULL ENABLE, 
	"APP_USER" VARCHAR2(96), 
	"CRÉÉ_LE" DATE DEFAULT CURRENT_DATE, 
	"COURRIEL" VARCHAR2(128) NOT NULL ENABLE, 
	 CONSTRAINT "PA_AUTORISATION_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   (	"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, 
	"PRENOM" VARCHAR2(128 CHAR) NOT NULL ENABLE, 
	"NOM" VARCHAR2(128 CHAR) NOT NULL ENABLE, 
	"TELEPHONE" VARCHAR2(96 CHAR), 
	"COURRIEL" VARCHAR2(128 CHAR) NOT NULL ENABLE, 
	"ADRESSE" VARCHAR2(512 CHAR), 
	"DATE_ADHESION" DATE
	ATE, 
	"BENEVOLE" VARCHAR2(48 CHAR), 
	 CONSTRAINT "PA_ADHERENT2_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   ) ;

CREATE TABLE "PA_ADHERENT" 
   (	"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, 
	"PRENOM" VARCHAR2(128 CHAR) NOT NULL ENABLE, 
	"NOM" VARCHAR2(128 CHAR) NOT NULL ENABLE, 
	"TELEPHONE" VARCHAR2(96 CHAR), 
	"COURRIEL" VARCHAR2(128 CHAR) NOT NULL ENABLE, 
	"ADRESSE" VARCHAR2(512 CHAR), 
	"DATE_ADHESION" DATE, 
	"BENEVOLE" VARCHAR2(48 CHAR), 
	 CONSTRAINT "PA_ADHERENT2_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   ) ;   

Here are the values of the tables:

INSERT INTO PA_ADHERENT (ID,PRENOM,NOM,TELEPHONE,COURRIEL,ADRESSE,DATE_ADHESION,BENEVOLE) VALUES (1,'Christian','DUPONT',0671642779,'cpitet@gmail.com','4  Avenue Jean Mermoz Viry-Chatillon','2026-19-07','Oui'), 
(21,'Bruno','DELVAL',NULL,'CPITET@GMAIL.COM','','','');

INSERT INTO PA_AUTORISATION (ID,PRÉNOM,NOM,CONSENTEMENT_AU_TRAITEMENT_DONNÉES_PERSONNELLES,CONSENTEMENT_AU_DROIT_À_IMAGE,AUTORISATION_DE_DIFFUSION_SUR_LES_RÉSEAUX_SOCIAUX_ET_LE_SITE_INTERNET,JE_SOUHAITE_RECEVOIR_LA_NEWSLETTER,JE_SOUHAITE_RECEVOIR_DES_INFORMATIONS_SUR_LES_EVÉNEMENTS_ET_LES_ATELIERS,APP_USER,CRÉÉ_LE,COURRIEL) VALUES (1,'Christian','DUPONT','Oui','Oui','Oui','Oui','Oui','ADMINISTRATEUR','2026-24-07','yyy@gmail.com'), 
(21,'Bruno','DELVAL','Non','Oui','Oui','Oui','Non','ADMINISTRATEUR','2026-27-07','xyz@gmail.com');

With these values, only one record should be returned, which is the record:

1,'Christian','DUPONT','Oui','Oui','Oui','Oui','Oui','ADMINISTRATEUR','2026-24-07','yyy@gmail.com'

How to do ?

Best regards.