fork download 
  1. create table wtransaction
  2. (
  3. emailfrom varchar(20) NOT NULL,
  4. emailto VARCHAR(20) NOT NULL
  5.  
  6.  
  7.  
  8.  
  9. );
  10.  
  11. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','gaukaugaukau@gmail.com');
  12. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','sunny.31');
  13. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','kaushik1');
  14. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','kalci1');
  15. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','kaka');
  16. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','gaukaugaukau1@gmail.com');
  17. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','gaukaugaukau2@gmail.com');
  18. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','gaukaugaukau3@gmail.com');
  19. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau@gmail.com','gaukaugaukau4@gmail.com');
  20. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau1@gmail.com','kaushik1');
  21. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau2@gmail.com','kalci1');
  22. insert into wtransaction (emailfrom,emailto) values ('gaukaugaukau4@gmail.com','kaka');
  23.  
  24.  
  25.  
  26. create table email
  27. (
  28. email varchar(20) NOT NULL
  29.  
  30. );
  31.  
  32. insert into email (email) values ('gaukaugaukau@gmail.com');
  33. insert into email (email) values ('gaukaugaukau1@gmail.com');
  34. insert into email (email) values ('gaukaugaukau2@gmail.com');
  35. insert into email (email) values ('gaukaugaukau3@gmail.com');
  36. insert into email (email) values ('gaukaugaukau4@gmail.com');
  37. insert into email (email) values ('sunny.31');
  38. insert into email (email) values ('kaushik1');
  39. insert into email (email) values ('kalci1');
  40. insert into email (email) values ('kaka');
  41.  
  42.  
  43. select * from wtransaction wt where  NOT EXISTS(select * from email e where NOT EXISTS (select * from wtransaction w where wt.emailto=e.email ));
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
Success #stdin #stdout 0s 2964KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
https://ideone.com/fqReyk
language:
SQLite (sqlite 3.27.2)
created:
11 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!