clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 582721 fiddles created (13320 in the last week).

create table t1 (account text, type text);
 hidden batch(es)


create table t2 (account text, amount real);
 hidden batch(es)


insert into t1 (account, type) values('a', 'student'), ('b', 'student');
 hidden batch(es)


insert into t2 SELECT 'a', 100 WHERE (select 1 from t1 where account = 'a' limit 1) = 1;
 hidden batch(es)


insert into t2 SELECT 'b', 500 WHERE (select 1 from t1 where account = 'b' limit 1) = 1;
 hidden batch(es)


insert into t2 SELECT 'c', 1000 WHERE (select 1 from t1 where account = 'c' limit 1) = 1;
 hidden batch(es)


select * from t2;
account amount
a 100
b 500
 hidden batch(es)