I have 2 tables in Oracle

Recipient

RecipientDeposit

I search to select every row in recipient (with same email and same editor) that doesn’t have any value in recipientDeposit

With that query, I get recipient that doesn’t exist in RecipientDeposit

SELECT re.id_recipient , re.editor_id, re.email FROM recipient re 
WHERE re.id_recipient NOT 
in 
   (SELECT rd.id_recipient FROM RecipientDeposit rd WHERE  re.id_recipient =rd.id_recipient)

I tried that

SELECT re.id_recipient , re.editor_id, re.email FROM recipient re 
JOIN (SELECT editor_id, email, FROM Recipient re2 GROUP  BY editor_id , email  HAVING count(* ) > 1 )  b ON da.editor_id = b.editor_id AND da.email = b.email
WHERE re.id_recipient NOT 
in 
   (SELECT rd.id_recipient FROM RecipientDeposit rd WHERE  re.id_recipient =rd.id_recipient)

but I’m really not sure.