Greetings. I need some help from you gurus to have multiple selects, but the sequence is important. For example,
create table t (a, b, c, d, e); insert into t values (1,2,3,4,5); insert into t values (2,2,3,4,5); insert into t values (3,3,3,3,3); insert into t values (4,1,1,1,1); insert into t values (5,1,1,2,2); insert into t values (6,2,3,2,2); what I want to do is to do a select that first chooses all items where e != 1, and then the result of that select be used to create more selects based on other criteria. For example, SELECT * from t WHERE a IN (SELECT a from t where e != 1); But I want to use the result of (SELECT a from t where e != 1); to run another select (SELECT a from t where d > 3); and then, one more select (SELECT a from t where c != 1 AND b != 1); and the final select would be "SELECT * from t WHERE a IN" which would have the result. I hope someone understands. :-) Thanks for the help. josé _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
