ers@sqlite.org" <sqlite-users@sqlite.org>
Sent: Wednesday, August 8, 2012 9:26 PM
Subject: [sqlite] insert two select count(*) problem
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
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
sqlite-users-
> boun...@sqlite.org] On Behalf Of YAN HONG YE
> Sent: Wednesday, 08 August, 2012 19:27
> To: sqlite-users@sqlite.org
> Subject: [sqlite] insert two select count(*) problem
>
> The sqlcmd is:
> insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>
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 command.
___
4 matches
Mail list logo