2012/8/9 YAN HONG YE <yanhong...@mpsa.com>: > 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.
INSERT INTO mydb (co1, co2) SELECT (SELECT count(*) FROM db1 WHERE sco1>80), (SELECT count(*) FROM db2 WHERE sco2>90); -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
