Hello SQLite users, Hello Dr. Hipp, I think I have found a bug related to UNION SELECT; try this:
CREATE TABLE Test1 (fld1) CREATE TABLE Test2 (fld2) INSERT INTO Test1 VALUES (1) INSERT INTO Test2 VALUES (1) SELECT * FROM Test1 UNION SELECT * FROM Test2 And I get only one record ? Shouldn't I get two records, both having 1 value ? Regards, George Ionescu