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 <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Simon Slavin <slav...@bigfraud.org> 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 <jic...@outlook.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
