Create table A(
ID number,
Address Varchar2(100))
;


Create table B(
sqlid number,
Vemail Varchar2(100))
;


Insert into A values (1083,'resale.x@att.com');

Insert into A values (1083,'tdoan@comt.com');

Insert into A values (1084,'Xyx@gh.com');

Insert into A values (1084,'abc@gh.com');

Insert into A values (1084,'fgt@pls.com');

Insert into A values (1001,'sthomas@TN.com');

Insert into A values (1001,'proxs@telep.com');

Insert into A values (1001,'cab@tow.net');

Insert into B values (1,'tdoan@comt.com');

Insert into B values (2,'sthomas@TN.com');

Insert into B values (3,'proxs@telep.com');

SQL> select * from a
  2  where not exists (select null
  3                    from a a2 join b on a2.address = b.vemail
  4                    where a2.id = a.id);
 
        ID ADDRESS
---------- --------------------------------------------------------------------------------
      1084 Xyx@gh.com
      1084 abc@gh.com
      1084 fgt@pls.com
 
SQL> 

SQL> select id, address
  2  from (
  3  select a.id, a.address, count(b.vemail) over(partition by a.id) cnt
  4  from a left join b on a.address = b.vemail
  5  )
  6  where cnt = 0;
 
        ID ADDRESS
---------- --------------------------------------------------------------------------------
      1084 abc@gh.com
      1084 fgt@pls.com
      1084 Xyx@gh.com
 
SQL>