Slavin
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 wrote:
> want to use the result of (SELECT a from t where e != 1); to run another
> select (SELECT a from t where d >
Thanks, Keith. Yep, exactly what I was looking for. Gracias.
From: sqlite-users on behalf of
Keith Medcalf
Sent: Wednesday, February 6, 2019 11:37 PM
To: SQLite mailing list
Subject: Re: [sqlite] Multiple SELECTs in one call
You mean something like
select
sts.sqlite.org
>Subject: [sqlite] Multiple SELECTs in one call
>
>
>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 va
On 7 Feb 2019, at 4:21am, Jose Isaias Cabrera 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
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
5 matches
Mail list logo