fork download
copy 
  1. with a as (
  2. select 1 id, 1 flag union all
  3. select 2, 0 union all
  4. select 4, 1
  5. ),
  6.  
  7. b as (
  8.   select 1 id union all
  9.   select 2 union all
  10.   select 3
  11.   select 4
  12. )
  13.  
  14. select b.id, a.flag != 1 as tf
  15. from b
  16. left join a
  17. using(id)
Success #stdin #stdout #stderr 0.01s 5288KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: near "select": syntax error
https://ideone.com/Z1cai9
language:
SQLite (sqlite 3.27.2)
created:
1 day 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!