80 ,select
count(*) from db2 where db2.sco2>90;
Try parenthesizing each (sub)query
insert into mydb (co1,co2) (...),(...);
Could you clarify your use case for this query?
Thanks
HTH.
From: YAN HONG YE
To: "sqlite-users@sqlite.org"
2012/8/9 YAN HONG YE :
> The sqlcmd is:
> insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>80 ,select
> count(*) from db2 where db2.sco2>90;
> It doesn't work. If one column, it can do,but when many column count(*), I
> don't know how to write the sql
insert into mydb (co1,co2) values ((select count(*) from db1 where
db1.sco1>80), (select count(*) from db2 where db2.sco2>90));
---
() ascii ribbon campaign against html e-mail
/\ www.asciiribbon.org
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
3 matches
Mail list logo