Re: [sqlite] insert two select count(*) problem

2012-08-09 Thread giris
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

Re: [sqlite] insert two select count(*) problem

2012-08-09 Thread Kit
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

Re: [sqlite] insert two select count(*) problem

2012-08-08 Thread Keith Medcalf
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>

[sqlite] insert two select count(*) problem

2012-08-08 Thread 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 command. ___