They are related by a, but I see that Keith prepared a nice answer. Thanks. And yes, UNION is the key here. I thought that it was to UNITE other tables, but I can see that I can use it with the same table. Thanks.
________________________________ From: sqlite-users <[email protected]> on behalf of Simon Slavin <[email protected]> Sent: Wednesday, February 6, 2019 11:30 PM To: SQLite mailing list Subject: Re: [sqlite] Multiple SELECTs in one call On 7 Feb 2019, at 4:21am, Jose Isaias Cabrera <[email protected]> wrote: > 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); How are these related to each other ? Do you want one big result which has the rows returned by the first SELECT, and also the rows returned by the second SELECT, and also the rows returned by the third SELECT ? If so, you use UNION: <https://www.w3schools.com/sql/sql_union.asp> Or did I get it wrong ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
