On Wed, Feb 27, 2019 at 9:20 PM Keith Medcalf wrote:
> [...] As such, except in OUTER joins, you do not even have to have the ON
> expression related to the table(s) which have been seen so far or even
> those in the join expression ...
because ON is merely a syntactic substitute for WHERE and
sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Jose Isaias Cabrera
>Sent: Wednesday, 27 February, 2019 07:42
>To: David Raymond; SQLite mailing list
>Subject: Re: [sqlite] Getting data from two JOIN tables
>
>
>Thanks, David. I actually like the comm
SQL, the language of the free... choices: JOIN or commas (,)... ;-)
From: sqlite-users on behalf of Dominique Devienne
Sent: Wednesday, February 27, 2019 09:47 AM
To: SQLite mailing list
Subject: Re: [sqlite] Getting data from two JOIN tables
On Wed, Feb 27, 2019 at 3:42 PM Jose Isaias
On Wed, Feb 27, 2019 at 3:42 PM Jose Isaias Cabrera
wrote:
> Thanks, David. I actually like the comma (,) than the words (JOIN,
> etc). Less wordy and, to me, more logically flow-y.
>
Just the reverse as myself. I much prefer explicit join-on, to separate
filtering from join-conditions in the
] On
Behalf Of Dominique Devienne
Sent: Wednesday, February 27, 2019 9:06 AM
To: SQLite mailing list
Subject: Re: [sqlite] Getting data from two JOIN tables
On Wed, Feb 27, 2019 at 2:18 PM Jose Isaias Cabrera
wrote:
> Thanks. This is exactly what I needed. So, there is really no JOIN here,
> or
lf Of Dominique Devienne
Sent: Wednesday, February 27, 2019 9:06 AM
To: SQLite mailing list
Subject: Re: [sqlite] Getting data from two JOIN tables
On Wed, Feb 27, 2019 at 2:18 PM Jose Isaias Cabrera
wrote:
> Thanks. This is exactly what I needed. So, there is really no JOIN here,
> or
Thanks, Dominique.
From: sqlite-users on behalf of Dominique Devienne
Sent: Wednesday, February 27, 2019 09:06 AM
To: SQLite mailing list
Subject: Re: [sqlite] Getting data from two JOIN tables
On Wed, Feb 27, 2019 at 2:18 PM Jose Isaias Cabrera
wrote:
> Thanks. This is exactly wha
On Wed, Feb 27, 2019 at 2:18 PM Jose Isaias Cabrera
wrote:
> Thanks. This is exactly what I needed. So, there is really no JOIN here,
> or is the "from t outer_t, z outer_z" a JOIN like statement? Where can I
> read more about this? And yes, your assessment of t(a, idate) and z(f,
> idate)
of
Keith Medcalf
Sent: Tuesday, February 26, 2019 10:46 PM
To: SQLite mailing list
Subject: Re: [sqlite] Getting data from two JOIN tables
select a, b, c, g, h, i
from t outer_t, z outer_z
where a == f
and a == 'p001'
and outer_t.idate == (select max(idate) from t where a ==
lite] Getting data from two JOIN tables
>
>
>Sorry to bother you with this simple request, but I can't seem to
>come up with a solution. Imagine these tables:
>create table t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate);
>insert into t (a, b, c, d, e, idate) values ('p001', 'a'
Sorry to bother you with this simple request, but I can't seem to come up with
a solution. Imagine these tables:
create table t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate);
insert into t (a, b, c, d, e, idate) values ('p001', 'a', 1, 'n', 4,
'2019-02-11');
insert into t (a, b, c, d, e,
11 matches
Mail list logo
