fork download
copy 
  1. create table entsal (
  2.   nombreS char,
  3.   referencia char,
  4.   tea numeric
  5. );
  6.  
  7. create table salidas(
  8.   vin char,
  9.   estado char,
  10.   referencia char
  11. );
  12.  
  13. insert into entsal values('h','a',1);
  14. --insert into entsal values('b','a',1);
  15. --insert into entsal values('u','a',1);
  16. --insert into entsal values('o','a',1);
  17.  
  18. insert into entsal values('a','b',1);
  19. --insert into entsal values('b','b',1);
  20. --insert into entsal values('c','b',1);
  21. --insert into entsal values('d','b',1);
  22.  
  23. insert into salidas values('z','a','a');
  24. insert into salidas values('d','a','b');
  25. insert into salidas values('a','a','b');
  26. insert into salidas values('e','a','a');
  27. insert into salidas values('r','a','z');
  28.  
  29. select * from entsal inner join salidas ON entsal.referencia = salidas.referencia;
Success #stdin #stdout 0s 3444KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
h|a|1|e|a|a
h|a|1|z|a|a
a|b|1|a|a|b
a|b|1|d|a|b
https://ideone.com/cunPsf
language:
SQLite (sqlite 3.27.2)
created:
7 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!