fork download
copy 
  1.  
  2. A = LOAD 'data1' AS (a1:int,a2:int,a3:int);
  3.  
  4. DUMP A;
  5. (1,2,3)
  6. (4,2,1)
  7. (8,3,4)
  8. (4,3,3)
  9. (7,2,5)
  10. (8,4,3)
  11.  
  12. B = LOAD 'data2' AS (b1:int,b2:int);
  13.  
  14. DUMP B;
  15. (2,4)
  16. (8,9)
  17. (1,3)
  18. (2,7)
  19. (2,9)
  20. (4,6)
  21. (4,9)
  22.  
  23. 	X = JOIN A BY a1, B BY b1;
Success #stdin #stdout #stderr 0.01s 5284KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 2: near "A": syntax error
Error: near line 4: near "DUMP": syntax error
Error: near line 5: near "(": syntax error
Error: near line 14: near "DUMP": syntax error
Error: near line 15: near "(": syntax error
https://ideone.com/Wn5BI4
language:
SQLite (sqlite 3.27.2)
created:
2 days 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!